MySQL query insert command syntax error 42000
Posted: Sun Nov 30, 2014 5:42 am
Code: Select all
$this->DBNAME //is the database name magic __get() ".usertable" which is the table to be accessed
$p['USER_NAME'] = "myname";
$p['USER_PASSWORD'] = crypt_512_encryption("password");
$insert_result = $this->db_query("INSERT INTO ".$this->DBNAME.".usertable (UserName, UserPassword, UserLastLogin) VALUES (\'".$p['USER_NAME']."\', \'".$p['USER_PASSWORD']."\', \'".date("M:D:Y:H:i:s")."\')");
Any idea?