So I have a column in MySQL though PHPMyAdmin that looks like this
When I insert through PHPMyAdmin into the table and not put anything in the time column it works and puts the time in, however when I do it through PHP with the following script
mysql_query("INSERT INTO `products`
VALUES ('', '$title', '', '$photo', '$price', '$details', '$description_short', '$description', '$dimensions', '$colour', '$scatid', '$type', '$brand', 'Y', '$size')") ;
(the third '' is the time column) it seems to put the timestamp as 0000-00-00 00:00:00
I have had a look around and seem to be doing everything right from looking through some other Stack Overflow posts.
Thank you in advance for your help