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 Quote 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? Quote 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 Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.