> I have a problem here again regarding the date comparison. I need to
> check the most recent date that was entered in mysql database in date
> format ("Y-m-d"), if the datetoday is a day or two days in advanced
> compared to the queried date.
> I need to make sure that the next inserted date in the mysql database
> whould be the next day of the last inserted date.
Wow...that's confusing. :)
You will probably want to look at the DATE_SUB and DATE_ADD functions in
MySQL. They are in the Date and Time section of Chapter 6 in the manual.
Something like this would insert the "date" and the day after it into
two columns in the database.
$date = '2002-10-31';
$r = mysql_query("INSERT INTO your_table (todaydate, tomorrowdate)
VALUES ('$date','$date' + INTERVAL 1 DAY)");
INTERVAL is a shortcut to the DATE_SUB and DATE_ADD functions.
---John Holmes...
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
