The_Anomaly
-
Posts
3 -
Joined
-
Last visited
Never
Posts posted by The_Anomaly
-
-
Thats seems to work fine, but when i change it to display more than 1 item the page is a blank white.
-
i have everything pretty much working but its displaying everything not just 5 at a time as i would like it to. I cant seem to find whats wrong. when i click the 1,2,3 links the page in the address bar says it has changed but all fields are still the same. Wanna take a look :)
[code]
<?php
require_once('Connections/nwodb.php');
@mysql_select_db("nwo") or die("ERROR--CAN'T CONNECT TO DB");
$limit = 5;
$query_Recordset1 = "SELECT * FROM person ORDER BY LastName ASC";
$result_count = mysql_query($query_Recordset1);
$totalrows = mysql_num_rows($result_count);
if(empty($page))
{
$page = 1;
}
$limitvalue = $page * $limit - ($limit);
//$query_Recordset1 = "SELECT * FROM person ORDER BY LastName ASC";
//$result = mysql_query($query) or die("Error: " . mysql_error());
$Recordset1 = mysql_query($query_Recordset1, $nwodb) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
if(mysql_num_rows($Recordset1) == 0)
{
echo("Nothing to Display!");
}
$bgcolor = "#E0E0E0"; // light gray
echo("<table>");
echo("<tr><td>");
echo("Member_ID");
echo("</td><td>");
echo("Last Name");
echo("</td><td>");
echo("First Name");
echo("</td></tr>");
while($row_Recordset1 = mysql_fetch_array($Recordset1))
{
if ($bgcolor == "#E0E0E0")
{
$bgcolor = "#FFFFFF";
}else
{
$bgcolor = "#E0E0E0";
}
echo("<tr bgcolor=".$bgcolor."><td width=\"20%\">");
echo ($row_Recordset1["Person_ID"]);
echo ("</td><td width=\"40%\">");
echo($row_Recordset1["LastName"]);
echo ("</td><td>");
echo($row_Recordset1["FirstName"]);
echo("</td></tr>");
}
echo("</table>");
//shows the previous # entries link
if($page != 1){
$pageprev = $page--;
echo("<a href=\"pagation.php=$pageprev\">PREV".$limit."</a> ");
}else
{
echo("PREV ".$limit." ");
}
//shows the number of pages that can be selected from
$numofpages = $totalrows / $limit;
for($i = 1; $i <= $numofpages; $i++)
{
if($i == $page)
{
echo($i." ");
}else
{
echo("<a href=\"pagation.php?page=$i\">$i</a> ");
}
}
//shows the next # enties link
if(($totalrows % $limit) != 0)
{
if($i == $page){
echo($i." ");
}else
{
echo("<a href=\"pagation.php?page=$i\">$i</a> ");
}
}
if(($totalrows - ($limit * $page)) > 0){
$pagenext = $page++;
echo("<a href=\"pagation.php?page=$pagenext\">NEXT ".$limit."</a>");
}else{
echo("NEXT ".$limit);
}
mysql_free_result($Recordset1);
?>
[/code]
I know its sloppy right now :|
Stuck on pagation
in PHP Coding Help
Posted