Numbering search results

arleen

I'm having trouble numbering my search results for a user database. My results page is limited to 15 records per page which correctly numbers each record 1 thru 15. However, when I select my "Next Page" link, the next set of 15 results are numbered 1 thru 15 again instead of 16 thru 30 and so forth. I know it has something to do with the looping but I am so brain-dead from looking at all of this so I'm hoping someone can help me. I've also searched several resources but I can't find the answer...

<?
$query = "SELECT userID, username, surname, fname, city, state
FROM users
WHERE userlevel <= 3
$order_by_str $sort_order_str $limit_str";
$result = mysql_query($query);
if(!$result) error_message(sql_error());
?>
<table>
<tr>
<th> </th>
<th>last name</th>
<th>first name</th>
</tr>
<?
$i = 0;
while ($query_data = mysql_fetch_array($result)) {
$bgcolor = ($i++ & 1) ? '#CCCCCC' : '#F5F5F5';
$userID = $query_data["userID"];
$surname = $query_data["surname"];
$fname = $query_data["fname"];
$username = $query_data["username"];
$city = $query_data["city"];
$state = $query_data["state"];
echo "<tr bgcolor=\"$bgcolor\">\n"
."<td>$i. </td>\n"
."<td>$surname</td>\n"
."<td>$fname</td>\n"
."</tr>\n";
}
?>
</table>
<?

echo "<br>\n";
echo "<div align=\"center\">";
if($page_num > 1) {
$prev_page = $cur_page - 1;
echo "[<a href=\"$PHP_SELF?action=list_records&sort_order=$org_sort_order&order_by=$order_by&cur_page=0\">Beginning</a>]  ";
echo "[<a href=\"$PHP_SELF?action=list_records&sort_order=$org_sort_order&order_by=$order_by&cur_page=$prev_page\">Previous Page</a>]  ";
}
if($page_num < $total_num_page) {
$next_page = $cur_page + 1;
$last_page = $total_num_page - 1;
echo "[<a href=\"$PHP_SELF?action=list_records&sort_order=$org_sort_order&order_by=$order_by&cur_page=$next_page\">Next Page</a>]  ";
echo "[<a href=\"$PHP_SELF?action=list_records&sort_order=$org_sort_order&order_by=$order_by&cur_page=$last_page\">End</a>]";
}
?>

chowdary

Hi Arleen,
I am wondering how you are displaying 15 records per page(Just curious)
because i couldn't find any such in you query or while displaying the result....Anyway your job is pretty simple.

    You have the page number in $cur_page variable isn't it use that to get the starting number ($i is not "0" always)

use this
if(!$cur_page){$cur_page=1;}
$i=($cur_page-1)*15;

Hope this works......

arleen

Hi Ajay,

Thanks for the quick response. Your solution sort of works. The numbering updates on each page up to somewhere between pages 12-14. When selecting [Next Page] or [End] for the last page of the results, the numbering seems to skip and lists the last results as 181-194. So far I have 209 names in the database (14 pages).

There has to be a better solution... It's now 5am and I'm sooo burned out on this.

In reference to your question on how I am displaying # records per page, I declared the limit in a string in an include:

$records_per_page = "15";

then:

$query = "SELECT COUNT(*) FROM $tblusers WHERE userlevel <= 3";
$result = mysql_query($query);
$query_data = mysql_fetch_row($result);
$ttl_users = $query_data[0];
$page_num = $cur_page + 1;
$total_num_page = $last_page_num = ceil($ttl_users/$records_per_page);

html_header();
echo "<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" align=\"center\">\n"
."<tr valign=\"top\">\n"
."<td nowrap><b>$ttl_users users found</b></td>\n"
."<td align=\"right\" height=\"25\" nowrap>Displaying page $page_num of $last_page_num</td>\n"
."</tr>\n"
."</table>\n";

$limit_str = "LIMIT ". $cur_page * $records_per_page . ", $records_per_page";
$query = "SELECT userID, username, surname, fname, city, state
FROM $tblusers
WHERE userlevel <= 3
$order_by_str $sort_order_str $limit_str";
$result = mysql_query($query);

Is my answer somewhere in this whole mess? Any additional help and/or suggestions are appreciated. Thanks.

Arleen.

Ajay wrote:

Hi Arleen,
I am wondering how you are displaying 15 records per page(Just curious)
because i couldn't find any such in you query or while displaying the result....Anyway your job is pretty simple.

    You have the page number in $cur_page variable isn't it use that to get the starting number ($i is not "0" always)

use this
if(!$cur_page){$cur_page=1;}
$i=($cur_page-1)*15;

Hope this works......