TalkPHP - View Single Post

Alan @ CIT · 01-15-2008, 05:09 PM

Edit: Didn't see the post above

Yes, just change the "LIMIT 1" to "LIMIT 4" if you want it to return the 4 rows with the highest rating

Don't forget that when you have changed the query, you will need to put your while() loop back in to loop through them

Alan.

01-15-2008, 05:09 PM	#12 (permalink)
Alan @ CIT Member of the Month The Frequenter Join Date: Apr 2005 Location: South UK Posts: 483 Thanks: 51	Edit: Didn't see the post above Yes, just change the "LIMIT 1" to "LIMIT 4" if you want it to return the 4 rows with the highest rating Don't forget that when you have changed the query, you will need to put your while() loop back in to loop through them Alan.