Jump to content

order a limit and then go to next page


only one

Recommended Posts


i was thinking of using a while loop to select the stuff from the database..

then every loop contains $i++;

 

but then i was stuk with where to put my if statement..

 

maybe if i tried

 

$page = $_GET


;

$pms = mysql_query("SELECT * FROM pm WHERE id='$pm_id' ORDER BY id DESC");

while ($message = mysql_fetch_array($pms) && $i<$page*15) {

$i++;

}

 

but again im stuck...

Easy was is to use a LIMIT statement with the query to select only as many records as you want per page and identify the start record for each page ...

 

$query = "SELECT * from $db_table WHERE id='$pm_id' ORDER by id DESC LIMIT $from, $limit";

 

Check the pagination tutorials if you need more help than that.

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.