Adding 90 days, and comparing dates

[RyanB88]

I am writing a small script and I have two simular date related questions.

1) I have stored in a DB a date such as 12/13/2008, but the date stored could be any previous date, not just todays date, what I need to do is add 90 days to the date and echo that to the user

2) I would like to compare today's date with the value generated in question 1 to determain if today is the date generated or before, or after, then depending on that set a boolean that I would use to either show an message to the user or not.

[PappaJohn]

MySQL provides a number of Date and Time functions that will do what you want.

For example, for #1, you can look into DATE_ADD()

[abduraooft]

1) I have stored in a DB a date such as 12/13/2008, but the date stored could be any previous date, not just todays date, what I need to do is add 90 days to the date and echo that to the user

Take some effort to change them to the datetime format. All your other operations will be simplified then!