SQL INSERT INTO查询出错

Question

I have following code written in PHP:

  $q = mysql_query("INSERT INTO logowania ('user','udane','ip') VALUES ($uid,0,'".ip()."')"); echo mysql_error();

Values of $uid and ip() are correct, you can trust me.

Structure of logowania table:

1   idlogowania     int(11)             

2   user    int(11) 

3   udane   tinyint(1)  

4   data    timestamp       on update CURRENT_TIMESTAMP     CURRENT_TIMESTAMP   ON UPDATE CURRENT_TIMESTAMP     

5   ip  text    utf8_polish_ci  

I don't know where is the error in the statement. MySQL gives:

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 ''user','udane','ip') VALUES (1,0,'79.184.7.44')' at line 1

I tried to debug that, but without successful ending. I know that could be very simple mistake, but human's vision isn't infallible...

Answer 1

Use back ticks for column name,otherwise they are treated as strings.

(`user`,`udane`,`ip`)