smerny Posted December 17, 2010 Share Posted December 17, 2010 SELECT * FROM `weeks` ORDER BY 'week' DESC LIMIT 1 is giving me 1 118 1 2 3 4 5 6 7 8 9 10 0 out of this table ID week p1 p2 p3 p4 p5 p6 p7 p8 p9 p10 pb 1 118 1 2 3 4 5 6 7 8 9 10 0 2 119 11 12 13 14 15 16 17 18 19 20 1 i don't understand this... why isn't it giving me the 119 row? Link to comment https://forums.phpfreaks.com/topic/221943-order-by-desc/ Share on other sites More sharing options...
PFMaBiSmAd Posted December 17, 2010 Share Posted December 17, 2010 Because you have single-quotes around 'week' in your query, making it a string instead of your column name. Link to comment https://forums.phpfreaks.com/topic/221943-order-by-desc/#findComment-1148500 Share on other sites More sharing options...
smerny Posted December 17, 2010 Author Share Posted December 17, 2010 ah... thanks Link to comment https://forums.phpfreaks.com/topic/221943-order-by-desc/#findComment-1148501 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.