如何以自定义顺序从mysql数据库中回送获取的数组数据？ [关闭]

Question

I have been trying to print out data from a database table in custom order like for example.. I have a table and that have alot rows and have one column as listing_type which have values like Gold,Premium,Silver,Free etc for each row..! so how I would be able to print the data from fetched array in order like at first it should echo all Gold and then Premium and then Silver and then Free etc like..!

Any help would be appreciated..Thanks waiting for your reply.!

Answer 1

Use an ORDER BY clause in your MySQL query like this:

SELECT * 
FROM `table` 
ORDER BY FIELD(`listing_type`, 'Gold', 'Premium', 'Silver', 'Free')

The MySQL function FIELD() returns the position of str in the given strings. With this, you can create a custom order to sort your results on.