Trying to paginate a code but having trouble.

[Chris Carter <chandan9sharma@xxxxxxxxx>]

Hi,

I am trying to paginate this to display just 4 results and use <Previous and
Next> options for pagination.

Please help.

<div class="content"><p><?php
// database information
include "includes/config.php";

$query="SELECT * FROM students LIMIT";

$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();

$i=0;
while ($i < $num) {

$a=mysql_result($result,$i,"a");
$b=mysql_result($result,$i,"b");
$c=mysql_result($result,$i,"c");
$d=mysql_result($result,$i,"d");


print'<div>
          <div class="border">
    <div class="sign"> '.$a.'  '.$b.'  </div>
					<div class="Content"><strong>Name: </strong>'.$c.'<br />
                      <strong>Price:</strong> '.$d.' <br />
		  </div>
</div><br />';
$i++;

}

?>

Thanks in advance,

Chris
-- 
View this message in context: http://www.nabble.com/Trying-to-paginate-a-code-but-having-trouble.-tp15485452p15485452.html
Sent from the Php - Database mailing list archive at Nabble.com.

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php