Insert Into Database

[cheeyim]

Hie All,

Can anyone tell me what's wrong with this query? I seem to have an error concerning the area near 'unlock' and $message

The $message and $title are extracted correctly and I also checked that it is inserted accordingly to the datatype in the table. I suspect it's the now() function?

$query = "INSERT INTO thread VALUES (1, 1, 1, now(), 0, 0, {$title}, 'unlock', {$message})";

Thanks!

[discostudio]

$query = "INSERT INTO thread VALUES 
(1, 1, 1, now(), 0, 0, '$title', 'unlock', '$message')";

Try using that for the $title and $message clumns.

Is the column you are trying to insert the NOW() function into a mysql DATE column or DATETIME.

If not make it so and it should work just fine.

[cheeyim]

Thanks! It's the single quote problem 🙂