I have been looking for an answer to a problem with sorting all day and cannot seem to find the correct answer. The following is my sql query:
SELECT Id, zone, xtime, xdate, temp, status FROM temp_log WHERE zone LIKE 'Unit%' ORDER BY Id DESC LIMIT 3
I know that the last 3 entries will contain the 3 units and I always get the last 3 entries in the table, however, I cannot seem to get the order correct. :
sometimes:
Unit03
Unit01
Unit02
or:
Unit01
Unit03
Unit02
sometimes it is the way I want it:
Unit01
Unit02
Unit03
What do I need to add to the query to get the zone names in the correct order? Or possibly a better way of doing what I want to do.
Thanks,
Troy