2009/10/23 Jeff <j...@platinumsynergy.com>: > I currently have a query like so: > > SELECT p.fldId, p.fldFName, p.fldLName, p.fldEmail, p.fldPhone, p.resellerId, > d.timezoneId, d.bestTime, d.lastDate, d.lastTime, d.lastConnected FROM > tblProspects as p LEFT JOIN tblProspectsDetails as d ON d.prospectId = > p.fldId WHERE p.uId = "46437" ORDER BY d.lastDate ASC, d.timezoneId DESC
You do not need to set a variable, just 'ORDER BY FIELD(timezoneId, ..., ..., ...)' : <url:http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_field> You could also use the IF() or CASE functions to achieve similar results. -- Jaime Crespo MySQL & Java Instructor Warp Networks <http://warp.es> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org