jonniejoejonson Posted December 17, 2008 Share Posted December 17, 2008 I have a date and time column in my table... i would like to select my data but order it by both date and time ASC... any ideas on how to do this... ORDER BY date AND time ASC? Quote Link to comment https://forums.phpfreaks.com/topic/137405-solved-order-by-2-rows/ Share on other sites More sharing options...
Mchl Posted December 17, 2008 Share Posted December 17, 2008 ORDER BY date ASC, time ASC Quote Link to comment https://forums.phpfreaks.com/topic/137405-solved-order-by-2-rows/#findComment-717978 Share on other sites More sharing options...
jonniejoejonson Posted December 17, 2008 Author Share Posted December 17, 2008 as simple as that... thanks for your help... cheer. Quote Link to comment https://forums.phpfreaks.com/topic/137405-solved-order-by-2-rows/#findComment-718039 Share on other sites More sharing options...
fenway Posted December 17, 2008 Share Posted December 17, 2008 But please don't use reserved keyword for field names!!! Quote Link to comment https://forums.phpfreaks.com/topic/137405-solved-order-by-2-rows/#findComment-718076 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.