Order results by its occurrence inside an array

[prw]

I wish to order my results by its occurrence inside the $status array.

 

Basically all of the results with the status 'New' are to be listed first, then the results with the status Today, Tomorrow, Soon and so on.

 

Is this possible, or is there alternatively a different approach to ordering my results how I desire?

 

$status = array('New', 'Today', 'Tomorrow', 'Soon', 'Future', 'Complete'); 

$display->get_results("SELECT * FROM todo ORDER by status DESC");

[PFMaBiSmAd]

You would use ORDER BY FIELD(....) - http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_field

 

ORDER BY FIELD(status, 'New', 'Today', 'Tomorrow', 'Soon', 'Future', 'Complete')

[Zane]

you could give them a numerical value instead.  Otherwise, they'll just be ordered alphabetically.

[prw]

That works PFMaBiSmAd, thanks!