I've been messing around with this query:<<previous 10 | next 10>>
Code: Select all
SELECT * FROM table LIMIT 0, 10Moderator: General Moderators
I've been messing around with this query:<<previous 10 | next 10>>
Code: Select all
SELECT * FROM table LIMIT 0, 10Code: Select all
$pid = $_GETї'pid']; // GRAB THE PAGE ID FROM GET
if(empty($pid) || $pid < 1){
$pid = 1;
} // CHECK THAT ITS REALLY A PAGE
$num = 10; // NUMBER PER PAGE
$end = $pid * $num;
$beg = $end - $num;
$qry = mysql_query("SELECT * FROM table LIMIT $beg, $end");