strange insert on Access table
Posted: Wed Nov 17, 2004 2:35 pm
hi all
can someone help with this:
i have this simple sql statement:
$title = addslashes($title);
$sql = "insert into project (project_title) values('$title');
but i got an error when inserting ex: $title = "project's name"
if i change $sql to:
$title = addslashes($title);
$sql = 'insert into project (project_title) values("'.$title.'");
i get a diferent error using the same value, but if i copy paste the statement
and run it on MS Access, i get no problem.
Does anyone had such similar problems whem using php+access using odbc?
thanks.
can someone help with this:
i have this simple sql statement:
$title = addslashes($title);
$sql = "insert into project (project_title) values('$title');
but i got an error when inserting ex: $title = "project's name"
if i change $sql to:
$title = addslashes($title);
$sql = 'insert into project (project_title) values("'.$title.'");
i get a diferent error using the same value, but if i copy paste the statement
and run it on MS Access, i get no problem.
Does anyone had such similar problems whem using php+access using odbc?
thanks.