Inserting time into mysql

[Schwalbach]

Hey,

I wrote this, and am getting this error:

Error adding submitted joke: You have an error in your SQL syntax near 'WHERE ID=' at line 6

Here is the code:

$dtime = date("l dS of F Y h:i:s A"); 

Here is the update

$sql = "UPDATE news SET 
		   data= '$news',
           author='$name',
           email= '$email',
		   mytime='$dtime',
           WHERE ID=".$number;

It is pointing towards the where id part, but I have never had a problem with that, been using it forever?

The row is:

Name Type Null
mytime varchar(255) Yes

Default
NULL

[sid]

mytime='$dtime',

remove the comma at the end of this line = its a nasty error i stumbled upon before... copy and paste related usually ;-)

[Schwalbach]

hehe,

Thank ya 🙂

Is there a reason for that that you know of?

Also, great timing, that was like 50 seconds tops 🙂

[sid]

hehe - i even had it posted before you could edit the "color" problem...

what reason did you ask for specifically?

[Schwalbach]

hehe, thanks man, I got the reasoning and everything(I hope 😛)

[sid]

no problem - im glad i could help...