Can anyone help me make a little PHP change...

[j_miguel_y]

I need a little modification. I want to show 10 results per page. This script shows all the rows from my database. How can I change it so it only shows the first 10 then 11-20, and so on. I want it to have also a link in the bottom like this: page"1 2 3 4 5...10" so the client can go to those results.

NOTE: i just want this script to run on one page and not run on different page when i select a different page number

<?
$result = mysql_query("select * from plant_info where $category = '$spec' order by item")
while ($row = mysql_fetch_array($result, MYSQL_BOTH))
{
//echo "THIS IS ROW ".$row;
echo '<tr><td width="15%">';

if ($row["image"] != ""){
    echo '<img width="100" src="photos/thumbs/' . $row["image"] . '">';
}else{
	echo '<img width="100" src="images/nophoto.gif">';
}
echo '</td><td valign="top">';
echo '<a href="details.php?id=' . $row["id"] .'&category=' . $category . '&spec=' . $spec . '"><font face="arial" size="3"><b>' . $row["item"] . '</b></font></a>';
echo '<br>Summary : <i>' . $row["difficulty"] .'</i>';
echo '</td></tr>';

}

echo "</table>";
echo "</body>";

?>

[sabu]

I never quite mastered getting this right, but perhaps I can set some guidelines I would look into as I went about making it.

First of all.. you need two database queries. One to find the total amount of rows, and the other to find ten of them based on your current page number.

The first query, or total number of rows, divided by 10 will return the amount of pages you have. Perhaps someone knows enough about this modulus thing to explain further for me in that department.

In terms of only showing it on the first page, just do a simple "if page is zero" check before showing it.

[j_miguel_y]

yes I know, about the mosulus and pages, but if I continue, the query loop will be reset giving me the same 10 rows over and over again

[jannoy]

what you are looking for is some sort of pagination??
try searching pagination here. There are lots of script here for pagination