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 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 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 Link to comment https://forums.phpfreaks.com/topic/13532-select-date-statement/#findComment-52428 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.