splitting query result into multiple pages

[redsox8185]

I finally got php to pull the information about of the mysql database tables.. however now I'm trying to find a script that sends the query results to multiple pages, like the way a search engine works. Does anyone know of any scripts that would be compatible with php 5.2.6??

Thanks,

Kyle

[redsox8185]

This is the code I'm currently using:

<?php

$con = mysql_connect ("localhost", "x", "x") or die ('I cannot connect to the database because: ' . mysql_error());
$db = mysql_select_db ("insurance", $con);





$data = mysql_query("SELECT * FROM info LIMIT 1, 30")
or die(mysql_error()); 

Print "<table border=1 cellpadding=3 height=100% width=100% bgcolor=6699CC>";
while($info = mysql_fetch_array( $data ))
{
Print "<tr>";
Print "<td>".$info['ID'] . "</td> ";
Print "<td>".$info['firstname'] . "</td> ";
Print "<td>".$info['lastname'] . " </td> ";
Print "<td>".$info['address'] . " </td> ";
Print "<td>".$info['city'] . " </td> ";
Print "<td>".$info['state'] . " </td> ";
Print "<td>".$info['birthdate'] . " </td> ";
Print "<td>".$info['telephone'] . " </td> ";
Print "<td>".$info['email'] . " </td></tr>";
}
Print "</table>";
?>

[NogDog]

If you do a search on something like "PHP query pagination" here and/or on the web you should find lots of info. There is also the PEAR Pager package if that's available or you can install it.