Database query help

[EquinoxWorld]

Hello everyone,

It's been a while since I coded anything and I was wondering what's wrong with this code snippet. I'm trying to insert a username of a member into a certain column in a table in the database. I'm using this code:

PHP Code:

$vbulletin->db->query_write("INSERT INTO 'table' ('column') VALUES ('".$vbulletin->userinfo['username']."')"); 


Every time I get a (1064) database error.

Am I missing anything here?? Thanks everyone.

[kh99]

The quotes around the table name and column name should be backquotes and not apostrophes (single quotes). Also, you should use the escape_string() function on the username before including it, or else if a username has a special character it will cause an error. So maybe this:

PHP Code:

$vbulletin->db->query_write("INSERT INTO `table` (`column`) VALUES ('".$vbulletin->db->escape_string($vbulletin->userinfo['username'])."')"); 


[EquinoxWorld]

That worked perfectly thanks kh99.

[Paul M]

You dont need the backticks, you could remove them completely.