i have the lot of data and i have to short data that has on Approval and Approval data with short id descending.
Like the following query:
$query = "select * from event ORDER BY FIELD(status, 'Approval') desc";
But when new data added in event table. as when new data added in table its status is on Approval. and when i show the data .data is not sorted with event id descending.
I am confused how to use both order by field and order by id descending please help
Thanks and Regards