This is a very simple MySQL SELECT project,
We need a PHP script that can use our current date format of 2010-06-17T05:32:07.0Z (UTC) to then select from the database 90 days from todays date and bring back the results between today and 90 days from today.
The timezone of the above date (UTC) will need to be converted to our local timezone (+10) during the MySQL select.
Example: today is 1st june 2010, so we need all results from between 1st june 2010 and 90 days ahead of 1st june 2010 we should then see the record of the date mentioned above, which is the 17th june 2010 in the results.
This MySQL SELECT **MUST** use the date format of 2010-06-17T05:32:07.0Z and **NOT** any other format.
Greetings,
Considering the knowledge and skill I have in PHP and MYSQL, I am really excited to work on this project.
I have understood clearly what you need done and would like to discuss this with you in detail.
Please let me know what you think.
Best regards,
Noman.