MySQL problem
Posted: Mon Jun 26, 2006 3:49 am
Hello Gents 
I have a small problem with a SQL query it says Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING
Heres the query:
I have a small problem with a SQL query it says Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING
Heres the query:
Code: Select all
public function addUser($arr)
{
$sql = "INSERT INTO
'user'
('LOCKED', 'LASTNAME', 'FORNAME', 'USERNAME', 'PASSWORD', 'ACCESS', 'ACTIVE', 'EMAIL', 'PHONE', 'JOB', 'UNTAXED_MINIMUM', 'UNEMPLOYMENT_INSURANCE', 'PENSION', 'IDCODE', 'BANK', 'ACCOUNT')
VALUES(\"0\", $arr['lname'], $arr['name'], $arr['username'], $arr['password'], $arr['access'], \"1\", $arr['email'], $arr['phone'], $arr['job'], $arr['min'], $arr['un'], $arr['pens'], $arr['idcode'], $arr['bank'], $arr['account']);";
}