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? Quote 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. Quote 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 Quote Link to comment https://forums.phpfreaks.com/topic/221943-order-by-desc/#findComment-1148501 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.