add to time

[phpbuild12]

Hello, I need to add 1 day to my time, I know how to do it if its normal date(), but here its different.

$datpos = strtotime($datumpos); // this is the date received from database

Now I need to add 1 day to this date, how do I do that with strtotime, so that later on I can compare?

[Weedpacket]

The manual page for [man]strtotime[/man] has an example of adding one day to the current time. Pass it $datumpos as a second argument as explained in the function's description.

[bradgrafelman]

Alternatively, why not let the DB tell you what information you want rather than manipulating it afterwards? For example, this:

SELECT dateCol FROM ...

could be changed to:

SELECT ( dateCol + INTERVAL 1 DAY ) futureDate FROM ...

if using MySQL as your DBMS.

[phpbuild12]

Great, thanks for the answers.