I'm trying to use the following to limit search results per page and index results pages. The index renders, but when I select a "next" or numbered page index, the query doesn't run again and I get a blank page instead. I've tried including my variables in the URL (index.php>variable=$variable&variable2=$variable2&page=$i , but that doesn't work either.
Any suggestions?
<?
if(!isset($page))
{
$page = 1;
}
else
{
$page = $page;
}
$max_results = 5;
echo "Page: $page".'<br><br>';
$from = (($page * $max_results) - $max_results);
echo "From: $from".'<br><br>';
echo "Max Results: $max_results".'<br><br>';
$result=mysql_query("select aid,title,firstname,lastname,injury_type,applieddate
from accident
LIMIT $from, $max_results ");
$num_rows = mysql_num_rows($result);
while (list($DBaid,$DBtitle,$DBfirstname,$DBlastname,$DBinjury_type,$DBdate)=mysql_fetch_row($result))
{
?>
<tr>
<td class="webbtd"><a href="acc-edit.php?aid=<? echo $DBaid?>"><? echo $DBtitle. ' ' .$DBfirstname. ' ' .$DBlastname?></a></td>
<td class="webbtd"><? echo $DBinjury_type?></td>
<td class="webbtd"><? echo $DBdate?></td>
</tr>
<?
}
?>
</table>
<?
$total_results = mysql_num_rows($result);
$max_results = 50;
$prev = ($page - 1);
$next = ($page + 1);
$total_pages = ceil($total_results / $max_results);
echo "total Pages: $total_pages".'<br><br>';
echo "<div align=center>";
if($page > 1)
{
echo "<<<a href=index.php?page=$prev> Previous</a> - ";
}
for($i = 1; $i <= $total_results; $i++)
{
if($i == $page)
{
echo " $i ";
}
elseif ($i > $total_pages)
{
echo "";
}
else
{
echo "<a href=index.php?&page=$i> $i </a>";
}
}
if($page < $total_pages)
{
echo " - <a href=index.php?page=$next>Next</a> >>";
}
if ($page = $total_pages)
{
}
echo "</div>";
?>
The code comes from here