Jump to content

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


sungpeng

Recommended Posts

$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.

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

 

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.