Re: ODBC problem.. addslashes doesn't seem to work for windows...
| From: | fredo | Date: | Sun, 11 Jun 2000 15:20:04 +0000 |
| Subject: | Re: ODBC problem.. addslashes doesn't seem to work for windows... | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-317@lists.php.net to get a copy of this message | ||
$username = addslashes($username);
// update UserInfo table
$db_query = "INSERT INTO UserInfo (Name, RollNumber, Email, Account, Type)
".
"VALUES ('$username', '$rollnumber', '$email',
'$accountname',
'$accounttype')";
$db_result = odbc_exec($db_conn, $db_query);
Still gives me next error,
Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Syntax error
(missing operator) in
query expression ''Olivier D\'Hooghe', 'd', 'd',
'd', '1')'., SQL state
37000 in SQLExecDirect in
common.php on line 102
Any ideas?