The error I get is:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/reeloneo/public_html/request/pagination.php on line 42
And the contents of the database will not be displayed
the php:
<html>
<head>
<title>pagination</title>
<style>
html {font-family:tahoma,verdana,arial,sans serif; font-size:62.5%;}
body {font-size:1.2em;}
table { font-size:1em; }
table tr th{
background-color:#ddb;
padding:0.2em 0.6em 0.2em 0.6em;
}
table tr td{
background-color:#eec;
margin:0.3em;
padding:0.3em;
}
</style>
</head>
<body>
<?php
include("db_connect.php");
$page = $_GET['page'];
$records_per_page = 15;
if(!filter_var($page, FILTER_VALIDATE_INT, 1))
$page=1;
echo "<h3>Showing results for page $page</h3>";
$offset = ($page-1) * $records_per_page;
$dir = strtoupper($_GET['dir']);
if($dir!="ASC" && $dir!="DESC")
$dir = "ASC";
$sort = $_GET['sort'];
if($sort!="name" && $sort!="meaning")
$sort = "name";
$result = mysql_query("SELECT * FROM date ORDER BY $sort $dir LIMIT $offset, $records_per_page");
echo "<table><tr><th>Name</th><th>Email</th><th>RM#</th><th>Trained</th><th>MM/DD/YY</th><th>HH:MM AM/PM</th><th>ID</th></tr>";
if($row = mysql_fetch_array($result)){
do{
echo "<tr><td>{$row["Fname"]} {$row["Lname"]}</td><td>{$row["email"]}</td><td>{$row["rnum"]}</td><td>{$row["trained"]}</td><td>{$row["month"]}/{$row["day"]}/{$row["year"]}</td><td>{$row["hour"]}:{$row["min"]} {$row["ap"]}</td><td>{$row["id"]}</td></tr>";
} while($row = mysql_fetch_array($result));
}
echo "</table>";
function build_url($filename, $key, $value){
$values = array();
$query_str = array();
parse_str($_SERVER['QUERY_STRING'], $values);
foreach($values as $k=>$v){
if($k!=$key){
$query_str[] = "{$k}={$v}";
}
}
$query_str[] = "{$key}={$value}";
return "$filename?".implode("&", $query_str);
}
echo "<p>Navigation</p>";
$count_result = mysql_query("SELECT COUNT(*) FROM date");
$count_row = mysql_fetch_array($count_result);
$count = $count_row["COUNT(*)"];
echo (($page>1)?"<a href='".build_url("pagination.php", "page", $page-1)."'>prev</a>":"prev")." | ";
for($i=1; $i<=($count/$records_per_page)+1; $i++){
if($i!=$page)
echo "<a href='".build_url("pagination.php", "page", $i)."'>$i</a>";
else
echo $i;
if($i<$count/$records_per_page)
echo " | ";
}
echo " | ".(($page<$count/$records_per_page)?"<a href='".build_url("pagination.php", "page", $page+1)."'>next</a>":"next");
echo "<p>Table Order</p>";
echo "direction : ";
echo $dir=="ASC"?"Ascending":"<a href='".build_url("pagination.php", "dir", "asc")."'>Ascending</a>";
echo " | ";
echo $dir=="DESC"?"Descending":"<a href='".build_url("pagination.php", "dir", "desc")."'>Descending</a>";
echo "<br/>";
echo "sort by : ";
echo $sort=="Lname"?"Lname":"<a href='".build_url("pagination.php", "sort", "Lname")."'>Last Name</a>";
echo " | ";
echo $sort=="email"?"email":"<a href='".build_url("pagination.php", "sort", "email")."'>Email</a>";
echo " | ";
echo $sort=="rnum"?"rnum":"<a href='".build_url("pagination.php", "sort", "rnum")."'>Room#</a>";
echo " | ";
echo $sort=="trained"?"trained":"<a href='".build_url("pagination.php", "sort", "trained")."'>Trained</a>";
echo " | ";
echo $sort=="month"?"month":"<a href='".build_url("pagination.php", "sort", "month")."'>Month</a>";
echo " | ";
echo $sort=="day"?"day":"<a href='".build_url("pagination.php", "sort", "day")."'>Day</a>";
echo " | ";
echo $sort=="year"?"year":"<a href='".build_url("pagination.php", "sort", "year")."'>Year</a>";
echo " | ";
echo $sort=="hour"?"hour":"<a href='".build_url("pagination.php", "sort", "hour")."'>Hour</a>";
echo " | ";
echo $sort=="min"?"min":"<a href='".build_url("pagination.php", "sort", "min")."'>Minute</a>";
echo " | ";
echo $sort=="ap"?"ap":"<a href='".build_url("pagination.php", "sort", "ap")."'>Am/Pm</a>";
echo " | ";
echo $sort=="id"?"id":"<a href='".build_url("pagination.php", "sort", "id")."'>ID</a>";
?>
</body>
</html>
