If I wanted to display the results, but use a particular one to start with then this code could work for you.
I want to start from the field called “inbox” in my list table.
I then do not get a duplicate, and if I just echoed out what I would always expect, then it would not have the adjoining date in the result either. It would be meaning less.. but this script fixes that! (Inbox could be any text. Change this for your text you want to start with, and list for your table)
|
1 2 3 |
$sql = "SELECT list FROM todolist ORDER BY FIELD(list,'Inbox') DESC, list"; |
