Trying to paginate a code but having trouble.

// 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'

> // database information
> include "includes/config.php";
>
> $query="SELECT * FROM students LIMIT";
>
> $result=mysql_query($query);

You need to use LIMIT offset, number.

eg:

limit 50, 10 <- start at position 50, get 10 records.

http://dev.mysql.com/doc/refman/5.0/en/select.html

To make this work reliably, you also need to order your results.

Unless you specify an 'ORDER BY' clause the database will return them in
any order it sees fit and probably won't order things correctly. It
might get it right a lot of the time but the only way to guarantee it is
to tell it how to order the results.

So you should end up with something like this:


$number_to_fetch = 10;

$start_page = (isset($_GET['Start'])) ? (int)$_GET['Start'] : 0;

$offset = $start * $number_to_fetch;

$query = "select * from students ORDER BY student_id LIMIT " . $offset .
", " . $number_to_fetch;

Then when you go to the next page, 'Start' will be 1.


--
Postgresql & php tutorials
http://www.designmagick.com/

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