Limiting printing output with continue option.

[bsachnoff]

I have a DB with 14 records. What I would like to do is print 6 records at a time and then a back/forward button to move to the next 6 and then to the next 2, etc... I am able to break it down into the 6,6 and 2. Yet I have no idea on how to put in a button to allow me to move back and forth. I am currently using a function for my printing. Is this even possible without using some sort of javascript or VB script? I would rather like to keep it all within the same subroutine without using VBS or JS. Here is what I have so far:

<?
$query = mysqli_query ($dbconnect,"select * from datatable")
or die ("the table Query FAILED!");
$numofrows = mysqli_num_rows($query);
if ($numofrows == 0)
die ("no data in table");
$printedrows=0;
$rownum=$numofrows;

/ Print Database /
do
{
print_table($rownum,$query);
$maxrows=$_POST['maxrows'];
$printedrows=$printedrows+$maxrows;
$rownuw=$rownum-$maxrows;
}

while ($printedrows<$numofrows);

<?
function print_table($rows,$query)
{
echo "<table border>";
for ($rowcounter=1;$rowcounter <= $maxrows;$rowcounter++)
{
$getrow = mysqli_fetch_array($query);
$rowid=$getrow['id'];
echo "<tr>";
echo"<td class='norm' align='left' valign='top'>";
?>
<a href="view_record.php?id=<?=$rowid?>"</a>
<?=$rowid?>
<?
echo"</td>";
echo"<td class='norm' align='left' valign='top'>";
echo $getrow['fname'];
echo"</td>";
echo"<td class='norm' align='left' valign='top'>";
echo $getrow['lname'];
echo"</td>";
echo"<td class='norm' align='left' valign='top'>";
echo $getrow['city'];
echo"</td>";
echo"</tr>";
}
echo"</table>";
$_POST['maxrows']=$maxrows;
return;
}
?>

Any help would be appreciated!

Thanks,

Brent

[visualAd]

Check this out: http://www.vbforums.com/showthread.php?s=&threadid=298755

There is a function there which genertates clickable links.

You can then use a query to retrieve the exact range of records which you want fro mthe table:

SELECT * FROM table LIMIT 10,5;

The above query will select records from number 11 to number 15.

[rachel2004]

Brent, you're referring to pagination if I understand your problem correctly. Here is a tutorial to do it with PHP (no JS or VBS):
http://www.phpfreaks.com/tutorials/73/0.php

[bsachnoff]

Rachel - exactly what I was looking for!

Thank you!

Brent

[bsachnoff]

In version 5 of MySQL it appears they have removed the mysql_results call (nor do they have a mysqli_results call). This forced me to make a call right after connecting to the DB as such:
$total_results = mysqli_num_rows(mysqli_query($dbconnect,"select * from datatable"));

This gets the total number of records right off the bat vs waiting until after the output has started. If you wait, you find out that mysql_results no longer exists and if you try to get a num_rows now, you have already set your query to limit it to $max_results.

Hope this helps others using MySql 5+

Brent