johnsmith153 Posted February 22, 2011 Share Posted February 22, 2011 SELECT field1 FROM table1 ORDER BY field2, field3 However I need to add something in so it also orders by a value that is returned from a calculation: SELECT field1 FROM table1 ORDER BY field2, (if field 4=="" and field 5==1 then order these records in order), field3 So they are ordered by field2, then the calculation, then field3 Quote Link to comment Share on other sites More sharing options...
mikhl Posted February 22, 2011 Share Posted February 22, 2011 Not entirely sure of what you mean, but does this help? if($field4 == "" && $field5 == 1) { $sql = "SELECT field1 FROM table1 ORDER BY field2, field4, field5, field3" } else { $sql = "SELECT field1 FROM table1 ORDER BY field2, field3" } If you have some code to show of what you have so far, may be able to help a little more. Quote Link to comment Share on other sites More sharing options...
johnsmith153 Posted February 22, 2011 Author Share Posted February 22, 2011 Thanks mikhl. This is what I needed: SELECT field1 FROM table1 ORDER BY field2, CASE WHEN field4='"" && field5=1 THEN 1 ELSE 0 END, field3 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.