10 results per page anyone?

[j_miguel_y]

I want to change this code so that it will only show 10 results (rows) per page. I am stumbled on this.

Here is the code:
<?
$result = mysql_query("select * from plant_info where $category = '$spec' order by item")

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>";

?>

[bodzan]

if($GET['from']==""){
$GET['from']=0;
}

$result = mysql_query("select * from plant_info where $category = '$spec' order by item LIMIT ".$GET['from'].","($GET['from']+10)) ;

Obviously for the previous nex page make links like:

<a href="somepage.php?from=<?php echo ($_GET['from']+10); ?>">next page</a>

if($GET['from']>=10){
<a href="somepage.php?from=<?php echo ($GET['from']-10); ?>">previous page</a>
}

You get the picture...

[Weedpacket]

Have a look at the FAQ; there are links to threads on this subject.