you can use this :
please send me your feedback OK !
<head>
<script language="javascript">
<!--
function submitNav(num) {
document.navigation.navigTo.value = num;
document.navigation.submit();
}
// -->
</script>
</head>
<? // Inside the body of your php file (i.e. database1.php3)
$database="shopping";
$host="localhost";
$user="root";
$password="";
if (! $dbh=mysql_connect($host,$user,$password))
{
echo mysql_error();
return 0;
}
mysql_select_db($database, $dbh);
$maxRow = 2; // No of records per page
$sqlString = "SELECT FROM titles"; // Your query
$numRows = mysql_num_rows(mysql_query($sqlString,$dbh));
$numPages = (int)(($numRows-1)/$maxRow + 1);
if (!$pageNo) {
$page = 1;
}
else {
if ($go) {
if ((!$navigGo)||($navigGo<1)||($navigGo>$numPages)) {
$page = $pageNo;
}
else {
$page = $navigGo;
}
}
else {
$pageNo += $navigTo;
$page = $pageNo;
}
}
$firstRow = ($page - 1) $maxRow; ?>
<form action="database1.php3" method="post" name="navigation">
<table width="500" border="0" cellspacing="0" cellpadding="2">
<input type="hidden" name="pageNo" value=<?echo "$page";?>>
<input type="hidden" name="navigTo">
<tr>
<td bgcolor="navy" colspan="3"></td></tr>
<tr>
<td align="left" width="100" bgcolor="#ddffee">
<? if ($page>1) { ?>
<input type="button" onclick="submitNav(-1)" value=" << ">
<? } ?>
</td>
<td align="center" bgcolor="#eeffff">
<? echo "[Page #$page of $numPages] --- ";?>
Go to page <input type="text" size="3" name="navigGo">
<input type="submit" name="go" value=" Go! ">
</td>
<td align="right" width="100" bgcolor="#ddffee">
<? if ($page<$numPages) { ?>
<input type="button" onclick="submitNav(1)" value=" >> ">
<? } ?>
</td></tr>
<tr>
<td bgcolor="navy" colspan="3"></td></tr>
</form>
</table>
<table border=1>
<?
$sqlString = "SELECT * FROM titles LIMIT "; // Put your query here
$sqlString = $sqlString . $firstRow . "," . $maxRow;
if (!$res = mysql_query($sqlString,$dbh))
{ echo "gagal koneksi";
exit; }
while ($row = mysql_fetch_row($res))
{ echo "<tr><td>$row[0]";
echo "<td>$row[1]";
echo "<td>$row[2]";
echo "<td>$row[4]";
}
?>
</table>
