PHP String to MYSQL datetime/timestamp

[richamark]

Hi there guys,

I'm trying to create my own online image gallery using PHP and MySQL and i'm having trouble inserting a datetime string from PHP into a datetime or timestamp field in MySQL...When I try and insert the value into MySQL it isn't inserted and the default MySQL value stays at 0000-00-00 00:00:00

This is the data I would be trying to insert, which is automatically created by extracting the 'Date Taken' value from an image.

["DateTimeStr"]=>
string(19) "2004-10-23 17:45:41

I'm sure this has been asked hundreds of times and is very easy to do I just can't find the answer...

Any help would be appreciated!

[bradgrafelman]

Looks fine to me... can you show us the code that forms the MySQL query as well as what the generated query looks like (e.g. echo out the query and copy/paste it here)?