[Solar-talk] Trying to insert a date field into MySQL database

[Cruz, Darwin]

I'm trying to figure out how to take a passed in date formatted as
'2007-12-31' and insert that into a MySQL database.
 
I've tried the following array set ups for my insert into database with
no luck:
 
    $eventInsert = array(
     'event_id'   => 'null',
     'event_summary' => $values['eventSummary'],
     'event_number'  => $values['eventNumber'],
     'event_type'  => $values['eventType'],
     'date'    => 'ADDDATE(\''.$values['eventDate'].'\', INTERVAL 31
DAY)',
     );
 
    $eventInsert = array(
     'event_id'   => 'null',
     'event_summary' => $values['eventSummary'],
     'event_number'  => $values['eventNumber'],
     'event_type'  => $values['eventType'],
     'date'    => $values['eventDate'],
     );
 
 
Everything else insert's fine but the date is just 0000-00-00 00:00:00
Is there some format I need to pass the date as so MySQL will recognize
the date field from Solar?
 
Thanks
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman-mail3.webfaction.com/pipermail/solar-talk/attachments/20071205/74a0ff45/attachment.html