i have a sql statement as this
$sqladd="INSERT INTO CLIENT (user) VALUES ('$user')";
if the $user value has single quote such as
$user="ford's tech support"; it will cause the sql error, so i have to use $user=str_replace("'", "''", $user); to avoid the sql statement error.
it was working fine on my server.
but when i move it to another server which use php and interbase too.
the value becomes "ford''s tech support". and actually, on that server, the single quote value in sql statement will not cause problem. and $user=str_replace("'", "''", $user); only add another single quote to the value unnecessary.
what is the set up difference cause the different results? i think it is a php ini issue.
thanks.
hui
