[SOLVED] date adding

[vampke]

Hi guys,

 

I need a little help with this script i'm working on.

I get the date stored in a mysql table (printing it in html returns: 2007-11-10)

Now I don't need to print that date, but I want to print the day AFTER that day (so in this example 2007-11-11)

 

I'm stuck here! calling $date +1 returns "2008"

 

What's the right way?

 

Thanks for helping!

[Azu]

Instead of

 

select date from table

 

Use

 

select date + interval 1 day from table

 

And voila it will be the day after. And of course you can replace the 1 with another number, or day with a different unit of time (E.G. second) and negative value to make it go back in time instead of ahead.

[vampke]

great stuff!

thanks a bunch!