";
echo "". $row['bus_name']." |
";
echo "". $row['description']." |
";
echo "| ". $row['phone']." | ". $row['www']." |
";
}
// build navigation links, first, prev, next, last
// start by counting the number or rows in table
// setup SQL
$sql = "SELECT COUNT(id) AS numrows FROM member_directory";
// do it
$result = mysql_query($sql) or die("Error, query failed");
// fill in $numRows
$row = mysql_fetch_assoc($result);
$numRows = $row['numrows'];
// figure out $maxPages
$maxPages = ceil($numRows/$rowsPerPage);
$self = $_SERVER['PHP_SELF'];
$nav = " Page $pageNum of $maxPages";
// first and previous link
if($pageNum > 1) {
$pageNum --;
$first = " [First]";
$prev = " [Prev]";
}
else { //were on first page dont print first and previous
$first = " ";
$prev = " ";
}
if($pageNum < $maxPages) {
$pageNum ++;
echo $pageNum; // debugging
$next = " [Next]";
$last = " [Last]";
}
else { // were on the last page dont print next and last
$next = " ";
$last = " ";
}
echo ''.$first . $prev . $nav . $next . $last.'
';
?>