Returning X Number Of Results Per Page

[Anon]

Hello,

I'm using the following code to pull links out of a database (in a particular category) and display them to the user...sorta like Yahoo! :

<?php
$HTTP_GET_VARS[´SubCat´];
$HTTP_GET_VARS[´Location´];
$db = mysql_connect("xxx", "xxx");
mysql_select_db("xxx",$db);
if ($Location) {
$result = mysql_query("SELECT URL, SiteName, Description FROM backcountry WHERE SubCategory = ´$SubCat´ AND Location = ´$Location´ AND Status <> ´HIDDEN´ ORDER BY SiteName",$db);
} else {
$result = mysql_query("SELECT URL, SiteName, Description FROM backcountry WHERE SubCategory = ´$SubCat´ AND Status <> ´HIDDEN´ ORDER BY SiteName",$db);
}
?>
.
.
Some HTML Stuff
.
.
.
</TD>
</TR>
<tr><td>
<ul>

<?php
if ($myrow = mysql_fetch_array($result)) {
do {
printf("<LI><A HREF=\" %s \">%s</A> - \"%s\"\n", $myrow["URL"], $myrow["SiteName"], $myrow["Description"]);
} while ($myrow = mysql_fetch_array($result));
echo "</ul>";
echo "</td></tr>";
echo "</table>";
.
.
.
More HTML Stuff
.
.
.
} else {
echo "Sorry, no records were found!";
}
?>

As it stands now, this code simply presents ALL the links that match the particular query...and can be over 100 links at times. What I would like to do is figure out a way to only show the, say, first 25 links, and then create links at the bottom of the list that will show the next 25, then the next, and so on...much like most search engines do it. Being new to PHP, I really have no idea how to do this, and would love a push in the right direction.

Thanks!

Mark

[Anon]

http://www.phpbuilder.com/columns/rod20001214.php3

[riemondi]

Here's a general idea. I'm sure it could be done more efficiently. Don't consider this working. I typed it really fast and didn't check it.

<?php

##a variable named start will hold the value of the link we are currently on

this is passed through the URL, and will not exist the first time the page is loaded

if ($start == "") $start = 0;

$result = my_query("select title,link from links order by title");
$rows = mysql_num_rows($result);

$count = 0;
$count_printed = 0;

while ( (list($title,$link) = mysql_fetch_row($result)) && ($count_printed < 25) ) {
if ($count >= $start) {
print "<a href=$link>$title</a><br>";
$count_printed++;
};
$count++;
};

for ($i = 0; $i < ($rows/25); $i++) {
print "<a href=thisfile?start=".($i * 25).">links page $i</a>";
};

[Anon]

Guys,

Thanks for the direction. I'll try and figure it out from here.

Mark