Hello David & all,
No, neither mysql_escape_string or
Yes, I am using MySQL, should have said that, sorry.
But anyway, even with both of these functions, the
data in the string containing the single quote as
in "Don't Look" is still being truncated at the
single quote mark.
Any other suggestions would be greatly appreciated.
[EMAIL PROTECTED] wrote:
Skip Evens wrote:
I'm brand spanking new to the list and have a
I was under the impression that addslashes() would
handle single quote marks in INSERT statements,
but when I execute the following:
$sql="UPDATE images SET orderno=$orderno,
...and $caption contains something like:
...the data is chopped off at the single quote mark.
How, if not addslashes(), does one handle this?
If you're using MySQl, try mysql_escape_string(), or
If using some other RDBMS, look for similar functions in their respective
You might also investigate the setting of the magic_quotes directive in
php.ini, or use
get_magic_quotes_gpc to return this value programmatically.
Hope this helps.
Big Sky Penguin, LLC
61 W Broadway
Butte, Montana 59701
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php