Now that was funny, that hurt and I think it might work. Now try taking the returned mysqli data object and coercing it into an associative array with something like (array)$data_set or unserialize($data_set) and then do a multidemsional uksort() or uasort().
Warmest regards, Peter Sawczynec Technology Dir. blūstudio 941.893.0396 [email protected] www.blu-studio.com -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Edward Potter Sent: Wednesday, February 10, 2010 8:47 AM To: MySQL SIG Cc: MySQL Subject: Re: [mysql] How To Randomize This SQL Query Output SELECT UNIQUE bridesmaid IN log cabin WITH brunette RAND blond who likes to party WITH newly single guy UPDATE redhead IN SELECT cabin #2 ORDER BY cougars. I think that's it? :-) Sent from my iPhone On Feb 10, 2010, at 7:48 AM, "Peter Sawczynec" <[email protected]> wrote: > 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 _______________________________________________ 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 _______________________________________________ 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
