Thread: Multiple pages
View Single Post
  #2 (permalink)  
Old November 24th, 2004, 12:31 PM
mani_he mani_he is offline
Friend of Wrox
 
Join Date: Aug 2004
Location: , , .
Posts: 117
Thanks: 0
Thanked 2 Times in 2 Posts
Default

hi usedcarsgbcom
As I can see you want to put the limit for outputing mysql result so check this code. maybe it shoud work for you:
$page = $_GET['page'];
$limit = 5;
$start = ($page - 1) * $limit;
$query = mysql_query("SELECT * FROM table WHERE LIMIT $start, $limit");

Regards
Mani_he

Reply With Quote