Hi experts, I have a data field, saved as varchar I know this is not practical but i would like to keep it like this please.
My question is how would i only return data from the database from todays date. and 60 days into the future? for example todays date is the 05/04/2011 and 60 days from now would be 05/06/2011 i would need all data between them two dates getting from the database.
Many thanks for your help.
The query i have so far is the following.
$sql = "SELECT customer_name, account_number, mobile_number, end_contract
ORDER BY end_contract ASC";
How would i change this to get my desired outcome?
Many thanks for your time.