phplee Posted June 18, 2004 Share Posted June 18, 2004 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 Link to comment https://forums.phpfreaks.com/topic/1876-limit-results-by-star-rating/ Share on other sites More sharing options...
PHP Monkeh Posted June 18, 2004 Share Posted June 18, 2004 What's the fieldname for the star rating? Link to comment https://forums.phpfreaks.com/topic/1876-limit-results-by-star-rating/#findComment-6111 Share on other sites More sharing options...
phplee Posted June 18, 2004 Author Share Posted June 18, 2004 it is AA_Rating Link to comment https://forums.phpfreaks.com/topic/1876-limit-results-by-star-rating/#findComment-6112 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.