Increment Date

Using PHP MySql

I have a date field that holds a date an order was placed "order_date"

What is the best way to increment the field in a record by one day.

Thanks

Try this:

$your_date = "2000-12-15";

$tomorrow = date_add($your_date, INTERVAL 1 DAY);

Hope this helps...
Tom

Of course, date_add is a mysql function, so

$tomorrow = date_add($your_date, INTERVAL 1 DAY);

wouldn't make much sense.

Rather, run a query like:
"SELECT DATE_ADD($your_date, INTERVAL 1 DAY) AS next_day";

Bye
Tom

I am getting all 00000 when I run this.

$result = mysql_query ("SELECT DATE_ADD('$date1', INTERVAL 1 DAY) AS next_day");

Am I doing something wrong

The data is orgininally being sent like this

$date1 = date("Y-m-d");

The field is definetly formated as date.

If you already have a value in the field and you want to increment the date by one day, then use this:

UPDATE your_table SET order_date = order_date + INTERVAL 1 DAY

you can add a WHERE clause if need be...

If you are trying to insert the current date plus one day, then do this (you don't need to create $date1 in php)

INSERT INTO your_table (order_column) VALUES (NOW() + INTERVAL 1 DAY)

you can add in your other columns, too.

If neither of these help, please explain more what you want...

---John Holmes...