[snip] It might be faster to instead of getting the list of cities and then in seperate queries get all hotels for each city, to just sort by city and fetch all, and in your application check if it has found a next city already. [/snip]
Of course, you could use a single crosstab query and get something like CITY1 Hotel1 Hotel2 Hotel3 Hotel4 CITY2 Hotel1 Hotel2 CITY3 Hotel1 Hotel2 Hotel3 CITY4 Hotel1 Hotel2 Hotel3 Hotel4 Hotel5 Jay Blanchard --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
