Insterting Datetime string into a mysql table

[dexter_sherban]

Hey everyone

 

I have an issue with and insert statement. Im trying to insert the current datetime to a table. Let the code speak for itslef

// the date fromat variable
$date = date("Y-d-m G:i:s");

if(isset($_POST['map'])){
$map=$_POST['map'];}

if(isset($_POST['type'])){
$type=$_POST['type'];}

if(isset($_POST['title'])){
$title=$_POST['title'];}

// File upload
if(isset($_FILES['filename']['name']) && $_POST['decision'] == "replay")
{
$target_path = "replays/";
$target_path = $target_path . basename( $_FILES['filename']['name']);
$_FILES['filename']['tmp_name'];

if(move_uploaded_file($_FILES['filename']['tmp_name'], $target_path))
{
    	echo "The file ".  basename( $_FILES['filename']['name']).
    	" has been uploaded<br>";
// Mysql query (where the issue arises)
	$insert = mysql_query("insert into replays (type, title, filename, author, map, date_time) VALUES ('$type','$title','$target_path','$username','$map','$date')");
	if ($insert)
	{
	echo "<font color='green'>A query referencing your file has been made</font><br>";
	}
	else
	{
	echo "<font color='red'>Notice. Mysql reference failed. The file might not be indexed. Check with admin</font><br>";
	}
}
else
{
// If the file was not uploaded
   echo "There was an error uploading the file, please try again!";
}
}

I keep getting the mysql query fail

 

however if i scrap the date column, it will work.

It also works if I have

$insert = mysql_query("insert into replays (type, title, filename, author, map, date_time) VALUES ('$type','$title','$target_path','$username','$map','0000-00-00 00:00:00')");

 

Did I forget to mention anything else that could be relevant?

Does anyone have any clues ?

[simcoweb]

It would be helpful if we knew the actual error. Replace this code:

 

$insert = mysql_query("insert into replays (type, title, filename, author, map, date_time) VALUES ('$type','$title','$target_path','$username','$map','$date')");

 

with this:

 

$insert = mysql_query("insert into replays (type, title, filename, author, map, date_time) VALUES ('$type','$title','$target_path','$username','$map','$date')") or die(mysql_error());

[dexter_sherban]

hhmm, right after i posted this, i did something else... i wrote something similar...im preety sure its the same and my error was :

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '13:49:09)' at line 1

 

edit :NONONONONON, thats not it...

 

Field 'rating' doesn't have a default value

 

Now rating is a int in the same table...and I wonder why it cares about its value.I can now fix this, but why woundt it leave it null, cause its not "not null".

 

[steve448]

Not certain but should:

$date = date("Y-d-m G:i:s");

Be:

$date = date("Y-m-d G:i:s");

 

[dexter_sherban]

scrap what I just said.

 

the actual error ur asking for is

Incorrect datetime value: '2007-20-10 14:02:25' for column 'date_time' at row 1

[dexter_sherban]

Success ! Tnx alot guys ! its was wrong datetime format

[Barand]

To insert current datetime

 

INSERT INTO table (datetimecol) VALUES (NOW() )