avo Posted July 3, 2006 Share Posted July 3, 2006 hi allCan you please help me out with this queryim would like to get a date from mysql db if the coloum date is <= todays date within 2 months but its not working[code]$sql="Select customer_name from office_1 WHERE date_com <= date_add('".date("Ymd")."', interval 2 month)";[/code]all help appriciated Quote Link to comment https://forums.phpfreaks.com/topic/13532-select-date-statement/ Share on other sites More sharing options...
redarrow Posted July 3, 2006 Share Posted July 3, 2006 http://www.1keydata.com/sql/sqlandor.html Quote Link to comment https://forums.phpfreaks.com/topic/13532-select-date-statement/#findComment-52395 Share on other sites More sharing options...
avo Posted July 3, 2006 Author Share Posted July 3, 2006 Hi Thanks Very interesting page .full of sql examplesCheers Quote Link to comment https://forums.phpfreaks.com/topic/13532-select-date-statement/#findComment-52428 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.