[RESOLVED] Date

I had atabe with a DATE column with default value 0000-00-00, but it is optional that is user can enter a date or just leave it blank.

How do I do to ensure that:

the date inserted will be 0000-00-00 and not 1970-01-01
when the table is updated and IF there is no changes to the DATE column, it will still holds the value 0000-00-00

I am using:
MySQL 5.0
PHP5.1.2

Well, when you UPDATE a row, it will only change the values you want. So if you don't change the value in the query, it will stay the same.

If you want the value to be 0000-00-00, then just define it that way:

$date = (!empty($_POST['date']))?$_POST['date']:'0000-00-00';

Then, in your query just use $date to insert the value into that column.

~Brett

Why not just set a default value for that column of 0000-00-00?

Thanks.