Simple ORDER BY

[johnsmith153]

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

[mikhl]

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.

[johnsmith153]

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