I have an application where each of the entries in the database has a price int field, and a contact enum('t','f') field.
I have a script that calls these entries from the database and sorts by price desc.
However, now I want the script to call these entries and sort them by price, however, if contact = 't' I want it to display all of those results first, then then, the remaining entries (which contact = 'f') by price desc.
If you have any suggestions, let me know.
Ben