Given the below query, I need to have this come out order random by Region, but with Sort_Order and Sort_Name still ordered naturally.
Any thoughts on this? SELECT DISTINCT Region, List_ID, Name, Address, Sort_Name, Thumb_File, Image_File, Logo_File, Sort_Order FROM WeddingAccommodation_Grid WHERE 1=1 AND ( ( S1_Cabin <> 0 ) ) ORDER BY Region, Sort_Order, Sort_Name Warmest regards, Peter Sawczynec Technology Dir. blūstudio 941.893.0396 [email protected] www.blu-studio.com _______________________________________________ New York PHP Community MySQL SIG http://lists.nyphp.org/mailman/listinfo/mysql NYPHPCon 2006 Presentations Online http://www.nyphpcon.com Show Your Participation in New York PHP http://www.nyphp.org/show_participation.php
