Can't solve query error.

[lszanto]

I have looked at my code a fair few times but I can't seem to see anything wrong but I am constantly getting an error, please see if you can spot the error.

 

thanks in advance, Luke

 

The error:

An Error Was Encountered

Error Number: 1064

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, entered, ip, date) values(null, 'Some Name', '49998e1b08a5bba53253ced8fa4ca' at line 1

INSERT INTO users(id, username, password, email, country, address, rank, key, entered, ip, date) values(null, 'Some Name', '49998e1b08a5bba53253ced8fa4ca6e234c83150', '[email protected]', 'Argentina', '12 Standup St', 'user', 1075172864, 0, '127.0.0.1', 2008-01-14 11:25 AM)

 

Insert statment:

		//Make query.
		$sql = "INSERT INTO users(id, username, password, email, country, address, rank, key, entered, ip, date) values(null, '$username', '$password', '$email', '$country', '$address', 'user', $key, 0, '$ip', $date)";

		//Run query.
		$this->db->query($sql);

[btherl]

Try `key` with backquotes around it.

[revraz]

Also, put single quotes around $date

[toplay]

 

$sql = "INSERT INTO users(`id`, `username`, `password`, `email`, `country`, `address`, `rank`, `key`, `entered`, `ip`, `date`) values(NULL, '$username', '$password', '$email', '$country', '$address', 'user', '$key', '0', '$ip', '$date')";