Multiple pages for one mysql query

[pablopicasso]

Hi,

Im really confused on how to get my mysql query to span over pages I would like it to be able to spread a large mysql query of over 100 over as many pages as needed. using maybe 50 results per page, or if that was adjustable it would make it even better...im really really confused about this so if someone could write me an example? that would be great.

thanks

pablo 😕 😕

[musicbase]

This is the code I use:

$messages = mysql_query("select * from messages  where 1 order by id2 desc LIMIT $start,50" , $link)

The important bit there is the LIMIT $start,50
This only selects 50 results, beginning from $start which will be defined in the URL in this code:

$num=0;
$pn=0;
echo "<br>Pages: ";
$tmsgs=mysql_num_rows(mysql_query("SELECT * FROM messages where 1"));


if ($start<>0)
{
$numap=$start-50;
echo "<a href='?start=$numap'>";} echo"Previous Page</a> |&nbsp;"; //changelink


while($tmsgs-$num>0){

$pn++;
if ($num<>$start)
{
echo "<a href='?start=$num'>$pn</a>&nbsp;|&nbsp;"; //changelink
}
else 
{
echo "$pn&nbsp; |&nbsp;";}

$num+=50;
}
$numa=$start+50;
if ($tmsgs-$numa>0)
{
echo"<a href='?start=$numa'>";} echo"Next Page</a>"; //changelink
}}

Insert that bit of code where you want the page links to show. If you need anyother query strings to be carried you need to add them on each line where I've written changelink.

Let me know if it works!

[pablopicasso]

Ok so ive put my own mysql query in but am having trouble getting the results to show???? where abouts in the code do i put them and how do i write it....i just used the $thing=mysql_result($result,$i,"feildname"); technque but i dunno if thats wright cos its not pulling anything up...also your next and previous arnt links when they are rendered as html???

heres the code im using (with login info removed obviously)..

<?
$username="";
$password="";
$database="";
$start=$_GET['start'];
mysql_connect("",$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$numresults = mysql_query("SELECT * FROM DrugsList WHERE DrugName LIKE '{$_GET['query']}%' ORDER BY DrugName DESC");
$tmsgs=mysql_num_rows($numresults);
if($tmsgs==0) {
echo "sorry no results"
exit();
$results = mysql_query("SELECT * FROM DrugsList WHERE DrugName LIKE '{$_GET['query']}%' ORDER BY DrugName DESC LIMIT $start,50 , $link");
$i=0;
while ($data = mysql_fetch_array($results)) {
?>
<tr><td><?=$data["DrugName"];?></td></tr>
<?
}
$num=0;
$pn=0;
echo "<br>Pages: ";
if ($start<>0)
{
$numap=$start-50;
echo "<a href='?start=$numap&query=" . $_GET['query'] . "'>";}

echo"Previous Page</a> |&nbsp;"; //changelink

while($tmsgs-$num>0){

$pn++;
if ($num<>$start)
{
echo "<a href='?start=$num&query=" . $_GET['query'] . "'>$pn</a>&nbsp;|&nbsp;"; //changelink
}
else 
{
echo "$pn&nbsp; |&nbsp;";}

$num+=50;
}
$numa=$start+50;
if ($tmsgs-$numa>0)
{
echo"<a href='?start=$numa&query=" . $_GET['query'] . "'>";} echo"Next Page</a>"; //changelink
?>