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

Reply via email to