MySQL syntax error?

$sql = "INSERT INTO league(user,email,password,rival,key) 
                    VALUES ('$this->user','$this->email','$this->pass','0','0')";

Error:

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 'key) VALUES ('user1','[email protected]','usrpsw','0','0')' at line 1

Key int(11) NULL(no) DEFAULT 0

Author: Smash, 2012-04-24

1 answers

$sql = "INSERT INTO league(user,email,password,rival,`key`) 
                    VALUES ('$this->user','$this->email','$this->pass','0','0')";

Key and other reserved fields should be taken in `

 4
Author: Nord001, 2012-04-24 12:13:05