how to add a day to a determined date.

[jbrill]

Hey guys,

I have an entry in the database that holds the date (Y-m-d). Im simply trying to add 1 day to it.

 

example: if the date in the database is 2009-04-06 in my php code i want to add grab that date and add 1 day to it so it would be 2009-04-07.

 

how would i go about doing this?

[revraz]

http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html

[jbrill]

Thanks for your help, but i want to do this in php, not using mysql. how would i do this?

[PFMaBiSmAd]

Slow parsed/tokenized/interpreted php code will require at least two function calls and will be 10-20 times slower than doing it in your SELECT query when you retrieve your existing date field. Why wouldn't you want to do it in your query?

[jbrill]

ok good call. My current query is:

 

"SELECT * FROM `user_forgot_password` WHERE `hash`='".$hash."'"

 

I have a "date" field that is date stamped when the user requested their password reset. I would like to give them one day to reset their password or else it would expire. how would i do this in an SQL statement?