<?PHP
mysql_connect("db_host","db_user","db_password");
mysql_select_db("db_database");
//
set up alternative query results
if(!$rowstart) $rowstart=0;
$result = mysql_query("select * from dbtable limit $rowstart,5");
$result2 = mysql_query("select * from dbtable");
$records=mysql_num_rows($result2);
?>
<html>
<?php
//
echo how many displaying if necessary
if ($records>5) echo "display
5 per page";
?> <?php
if
($rowstart>$numrows)
{?> </P><DIV
ALIGN="LEFT"><P>
<IMG SRC="images/previous.gif"
WIDTH="11" HEIGHT="16" ALIGN="ABSMIDDLE" BORDER="0"
ALT="Previous Page">
<A HREF="<?
$php_self ?>?rowstart=<? echo $rowstart-5;?>">
<FONT
FACE="Verdana, Arial, Helvetica, sans-serif" SIZE="1">Previous
Page</FONT></A> <?
}?> <?php
//use
2 images as well - previous.gif and next.gif
$numrows=mysql_num_rows($result2);
if($rowstart+5<$numrows)
{?><A HREF="<? $php_self?>?rowstart=<?echo $rowstart+5
;?>"><FONT FACE="Verdana, Arial, Helvetica, sans-serif"
SIZE="1">Next
Page</FONT> <IMG SRC="images/next.gif"
WIDTH="11" HEIGHT="16" BORDER="0" ALT="Next
Page" ALIGN="ABSMIDDLE"></A>
<? }?> <?php
//
and then do normal database query stuff
$num_rows
= mysql_num_rows($result);
if ($myrow = mysql_fetch_array($result)) {
echo
"eg $records available";
} else {
echo "Sorry, no records
available";
} </html>
| 
Back