Using PHP and MySQL, have a table that has a field with the DATE data type. Hence all records have a format similar to 2008-05-24. Using PHP I can select the date from the mysql table and assign it a variable ($date_old). Then, using PHP I need to add 10 days to the date and assign the new date to a new variable $date_new. How do I do this and preserve the format.
So if $date_old = '2008-05-24', I need $date_new = '2008-06-03'
How can I do this using PHP? If I cant use PHP, how can I do this using something compatible with PHP and MySQL?