Jump to content

Archived

This topic is now archived and is closed to further replies.

phplee

limit results by star rating

Recommended Posts

does anyone know the code that i would need to limit information from a database (MYSQL) so.. if i was listing hotels and wanted to put them on seperate pages, 5 stars on one page and 4 stars on another and so on, what do i need to do to get this???

 

is it something to do with

 

$query = "SELECT * FROM MYTABLE ORDER BY AA_Rating DESC LIMIT";

$result = mysql_query($query) or die("Error: " . mysql_error());

 

this selects all my info from the database, what needs to be changed or added so i only get 5 star hotels.

 

regards

phplee

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.