0
(This code from someone else, I try it but not work)
<?php
$rown="3"; //number of rows to be display each page
$query="SELECT * FROM products";
$result=mysql_query($query);
$numrows=mysql_num_rows($result);//total number of rows equal to $trows;
if(!isset($start)) { // This variable is set to zero for the first page
$start = 0;
}
print 'start = ' & $start;
$query ="$query limit $start,$rown"; //limit output $rown=5 rows starting $start
$result=mysql_query($query);
print"<table border=0>
<tr>
<td>Product id</td>
<td>Product name</td>
<td>Product group</td>
<td>Picture name </td>
</tr>";
while ($row=mysql_fetch_array($result)) {
print"<tr>
<td>$row[0]</td>
<td>$row[1]</td>
<td>$row[2]</td>
<td>$row[3]</td>
</tr>";
}
print"</table>";
print"<table><tr>
<td>".first($start,$numrows,$rown)."</td>
<td>".previous($start,$numrows,$rown)."</td>
<td>".next1($start,$numrows,$rown)."</td>
<td>".last($start,$numrows,$rown)."</td>
</tr></table>";
print 'start1 = ' & $start;
//============================================================
?>
Edited by ssmony, 11 September 2008 - 04:27 AM.
