I have 6 records (6 rows in DB). I want to print out 3 recods per page, it works fine. I want to count and print the number that match with the record number, for example
on the first page it displays
1.-------(record1)
2.-------(record2)
3.-------(record3)
but when I click next it goes to the second page
1.-------(record4)
2.-------(record5)
3.-------(record6)
I want it to display
4.-------(record4)
5.-------(record5)
6.-------(record6)
Please help ! below is my code:
$connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!");
// select database
mysql_select_db($db) or die ("Unable to select database!");
mysql_query("SET NAMES utf8");
if (!(isset($pagenum)))
{
$pagenum = 1;
}
// create query
$query = "SELECT * FROM techNeed where state='Alabama' order by city";
// execute query
$data = mysql_query($query) or die ("Error in query: $query. ".mysql_error());
$rows=mysql_numrows($data);
$page_rows = 3;
//This tells us the page number of our last page
$last = ceil($rows/$page_rows);
//this makes sure the page number isn't below one, or more than our maximum pages
if ($pagenum < 1)
{
$pagenum = 1;
}
elseif ($pagenum > $last)
{
$pagenum = $last;
}
//This sets range that we will display in our query
$max = 'limit ' .($pagenum - 1) * $page_rows .',' .$page_rows;
$result = mysql_query("SELECT * FROM techNeed where state='Alabama' order by city $max") or die(mysql_error());
$count=1;
while($info = mysql_fetch_array($result))
{
$salonName=mysql_result($result,$i,"salonName");
$city=mysql_result($result,$i, "city");
$state=mysql_result($result,$i,"state");
$phone=mysql_result($result,$i,"phone");
echo " <table border='1' cellpadding='1' bgcolor='#D5EAEA' width='900'>
<tr><td>$count</td><td>$salonName</td><td >$city </td></tr>
<tr><td> </td><td>$state</td><td>$phone</td></tr>
</table>";
$i++;
$count ++;
echo "<br>";
}
if ($pagenum == 1)
{
}
else
{
$previous = $pagenum-1;
echo "<b><a href='{$_SERVER['PHP_SELF']}?pagenum=$previous'> << Trở Lại</a> ";
}
$next = $pagenum+1;
for($k = 1; $k <= $last; $k++){
if(($pagenum) == $k){
echo "<b>$k ";
} else {
echo "<b><a href='{$_SERVER['PHP_SELF']}?pagenum=$k'>$k</a> ";
}
}
if ($next == $last+1)
{ echo "<b> Hết ";
}
else {
echo "<b><a href='{$_SERVER['PHP_SELF']}?pagenum=$next'>Trang Kế >></a> ";
}
?>