at first glance i'd assume that the variable $category is not being passed through to the second page - you're using it to get the first query, but not keeping it (either in the url or hiddenform variable for your next page link).
-----Original Message----- From: Natividad Castro [mailto:[EMAIL PROTECTED]] Sent: 23 May 2002 13:13 To: [EMAIL PROTECTED] Subject: [PHP-DB] displaying records Hi to all, I'm displaying a set of records in different pages. The user will be able to search by category, let say a user wants to search projects that belong to 'PHP' category, so I will list all the projects that belong to that category. My problem is: the first 10 records on the first page display without any problem, but when I try to go to the next page it doesn't display any record. The weird thing is that if I write my query: SELECT * FROM 150BK WHERE CATEGORY='PHP', I don't any problem I can see all my record and go through from page to page. But when I write my query requesting the name from the drop down menu from the search page I get just the first 10 records. For example, SELECT * FROM 150BK WHERE CATEGORY='$category' //here is where the problem Any help is greatly appreciate Thanks in advanced Nato here is my code <? include "./connection.php"; ?> <html> <head> <title>Record Set Paging with Page Navigation</title> </head> <body> <font face='verdana, arial' size=3><b> PHP/MySQL Record Set Paging with Page Navigation</b><font size=2><br> <? global $limit, $sql, $url, $pagesize, $pagecount, $absolutepage, $recordcount; $sql = ("SELECT * from 150bk wehere category='$category'"); $result = mysql_query($sql); $record_count = mysql_num_rows($result); $pagesize = 10 ; $url = $PHP_SELF ; if (!isset($absolutepage)) { // Set offset and absolutepage if not set $absolutepage = 1; $offset = 0; } else { $offset = ( $absolutepage - 1 ) * $pagesize ; } if (!isset($total_rows)) { // Get total_rows at startup $result = mysql_query($sql); $recordcount = ( mysql_num_rows($result) ) -1; $pagecount = intval($recordcount / $pagesize); if ($recordcount % $pagesize ) $pagecount++; } if ($recordcount > 0) { $sql .= " LIMIT $offset, $pagesize "; // Get record set = pagesize every time $result = mysql_query($sql); if ($absolutepage == 1) { $pag1 = $absolutepage; } else { $pag1 = (($absolutepage - 1) * $pagesize) + 1; } $pag2 = $pag1 + ($pagesize - 1); if ($pag2 > $recordcount) $pag2 = $recordcount; echo "<hr><font face='verdana, arial' size=2>"; echo "Displaying records $pag1 to $pag2 (of " . $recordcount.")<hr>"; PagNav($pagesize, $pagecount, $absolutepage, $recordcount, $sql, $url) ; echo "<hr>"; $fields = mysql_num_fields($result); for ($i=0; $i < $pagesize; $i++) { while($query_data = mysql_fetch_array($result)) { $id = $query_data[ID]; $name = $query_data[NAME]; echo $id. " | ".$name. " " . "<a href='resPNav2.php?test=$id'>read more..." . "</a>" . "<br>"; echo "<hr>"; } echo "<br>\n"; } } else { echo "No records found."; } echo "</body></html>"; function PagNav($pagesize, $pagecount, $absolutepage, $recordcount, $sql, $url) { global $sql, $url, $pagesize, $pagecount, $absolutepage, $recordcount; $pad="" ; $maxpages = $pagecount ; if ( ($absolutepage % 10) == 0) { $counterstart = $absolutepage - 9 ; } else { $counterstart = $absolutepage - ($absolutepage % 10) + 1 ; } $counterend = $counterstart + 9 ; echo "<font size=1><b>Page ".$absolutepage." of ".$pagecount.": </b>"; if ($counterend > $maxpages) $counterend = $maxpages ; if ($counterstart != 1) { $ref = "<a href='" . $url ; $ref .= "?absolutepage=" . "1" ; $ref .= "'>First</a> | " ; echo $ref ; $ref = "<a href='" . $url ; $ref .= "?absolutepage=" . ($counterstart - 1) ; $ref .= "'>Prev 10 Pages</a> " ; echo $ref ; } echo "<b>[ </b>" ; for ($counter = $counterstart; $counter < $counterend +1;$counter++ ) { if ($counter >= 10) $pad="" ; if (! ($counter == $absolutepage)) { $ref = "<a href='" . $url ; $ref .= "?absolutepage=" . $counter ; $ref .= "'>" . $pad . $counter . "</a>" ; } else { $ref = "<b>" . $pad . $counter . "</b>" ; } echo $ref ; if (!($counter == $counterend)) print " " ; } echo "<b> ]</b>" ; if ($counterend != $maxpages) { $ref = " <a href='" . $url ; $ref .= "?absolutepage=" . ($counterend + 1) ; $ref .= "'>Next 10 Pages</a>" ; echo $ref ; $ref = " | <a href='" . $url ; $ref .= "?absolutepage=" . $maxpages ; $ref .= "'>Last</a>" ; echo $ref ; } echo "</font>"; } ?> -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php