MySQL error in a REALLY simple query.

[tibberous]

insert into log (what, when) values ('test', '1191020046')

 

I get a syntax error.

 

Any idea why?

[pocobueno1388]

Well, you need to show your exact code.

 

It should look like this:

 

<?php

$query = "INSERT INTO log (what, when) VALUES ('test', '1191020046')";
$result = mysql_query($query)or die(mysql_error());

?>

[teng84]

show us whats the error your getting or maybe log is  a reserve word try adding tick `

insert into `log` (what, when) values ('test', '1191020046')

[Barand]

"WHEN" is a mysql reserved word. LOG is OK

 

Change the column name or use `when` (note back ticks not single quotes)

 

 

http://dev.mysql.com/doc/refman/4.1/en/reserved-words.html

[tibberous]

"WHEN" is a mysql reserved word. LOG is OK

 

Change the column name or use `when` (note back ticks not single quotes)

 

 

http://dev.mysql.com/doc/refman/4.1/en/reserved-words.html

 

Yep, you are right.

 

Thanks.