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', 'someemail@email.com', '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);