Im Confused? trying to understand where to echo the data in the
example to display page results: My tables are still messy.
Here's what I have:
<?
// inculded connnection code here
// set number of results to display per page
$pagelimit = "1";
$sql_result = mysql_query("SELECT * FROM members ORDER BY lname", $db);
// count number of matches
$totalrows = mysql_num_rows($sql_result );
// determine how many pages there will be by using ceil() and dividing total rows by pagelimit
$pagenums = ceil ($totalrows/$pagelimit);
// if no value for page, page = 1
if ($page==''){
$page='1';
}
// create a start value
$start = ($page-1) * $pagelimit;
// blank matches found
echo "<b>" . $totalrows . " matches found</b><br>\n";
// Showing Results 1 to 1 (or if you're page limit were 5) 1 to 5, etc.
$starting_no = $start + 1;
if ($totalrows - $start < $pagelimit) {
$end_count = $totalrows;
} elseif ($totalrows - $start >= $pagelimit) {
$end_count = $start + $pagelimit;
}
echo "Results $starting_no to $end_count shown.<br>\n";
// create dynamic next, previous, and page links
/ lets say you're set to show 5 results per page and your script comes out with 7 results.
this will allow your script to say next2 if you're on the first page and previous5 if you're on the second page. /
if ($totalrows - $end_count > $pagelimit) {
$var2 = $pagelimit;
} elseif ($totalrows - $end_count <= $pagelimit) {
$var2 = $totalrows - $end_count;
}
$space = " ";
// previous link (make sure to change yourpage.php to the name of your page)
if ($page>1) {
echo "« <a href='viewMember.php?page=".($page-1)."' class=main>Previous" . $space . $pagelimit . "</a>" . $space . $space . "";
}
// dynamic page number links (make sure to change yourpage.php to the name of your page)
for ($i=1; $i<=$pagenums; $i++) {
if ($i!=$page) {
echo " <a href='viewMember.php?page=$i' class=main>$i</a>";
}
else {
echo " <b class='red'>$i</b>";
}
}
// next link (make sure to change yourpage.php to the name of your page)
if ($page<$pagenums) {
echo "" . $space . $space . $space . $space . " <a href='viewMember.php?page=".($page+1)."' class=main>Next " . $var2 . "</a> »";
}
/* output your data wherever you'd like.
BUT
in order for this all to work, before outputting your data, you have to run the query over using MySQL's LIMIT. This will limit how many results are actually displayed on the page. */
$rs = mysql_query("SELECT * FROM members ORDER By lname LIMIT $start,$pagelimit");
// LIMIT 0,10 will start at 0 and display 10 results
// LIMIT 10,5 will start at 10 and display 5 results
/ now you can do whatever you'd like with this query. it will only output one page at a time. change the $pagelimit variable to whatever to output more than 1 result per page. /
echo "\n<table border =\"1\" bordercolor=\"1e569f\" width =\"500\" align =\"center\">";
//while ($rs = @ mysql_fetch_array ($sql_result))
echo "\n<tr>\n\t<td>" .
"<b> <font color=\"white\">".
$rs["fName"] . " " .
$rs["mName"] . " " .
$rs["lName"] . " " .
"</td> " .
"<td align =\"center\">" ."<a href=\"viewMember.php?memberID=" .$rs["memberID"] . "\">view</A>".
"</td></tr>";
//blank row for presentation
//echo "\n<tr>\n\t<td></TD>\n</tr>";
//}
//echo "\n</table>\n";
?>
Thanks,
cherylw
