displaying a set number of rows per page

[Anon]

I want to display a set number of results per web page. Let's say I have 20 rows of results, and I want to print out only 8 per page. I'm still a newbie--how would I code this?

For the full result set I have (simplified and taking out the table):

while ($business = mysql_fetch_array($businesses)) {
$id = $business["ID"];
echo($id);
{

[trooper]

Susan

Use the LIMIT keyword in your sql query

e.g

SELECT * from <table> where <whatever_clause> LIMIT <number_of_rows_to return>

Gary Mailer

[Anon]

Thanks, Gary,

This newbie was looking for the answer in php when the answer was sql. I find learning how all these parts fit together quite a fun challenge--like determining: "before the ?>, no after... Ah, shucks, my code displayed on the web page again!"

Susan