[SOLVED] display 200 results from page 1 to page 10

[sungpeng]

$selectquery = "SELECT * FROM listings where rid=$_GET[rid]";
$result = mysql_query($selectquery) or die ("Query failed");
while ($row = mysql_fetch_array($result))
{

echo "$row[description]";

}

 

Check my $row[description] will give me 200 results, can I display it from page 1 to page 10 instead of all in one page.

[SWD]

Hey sungpeng,

Use the LIMIT keyword in your SQL.   

The syntax is basically LIMIT <START RECORD>, <NUM RECORDS TO RETURN>

 

So therefore for the first 10 records you would have

SELECT ....

FROM ...

WHERE....

LIMIT 0,10

 

For the 60-70 records you would have

SELECT ....

FROM ...

WHERE....

LIMIT 60,10

 

Be careful with "one-off" overlaps... .but that should do the trick.

 

Good luck

LP

 

[sungpeng]

ok but sometime I have 25 results only then I need it to display 3 pages only instead of 10 pages that is preset and viewers can click next to go to next pages. It is common but I need some advise on coding it.

[.josh]

what you want is called pagination.

 

http://www.phpfreaks.com/tutorial/basic-pagination