Hello all,

I'm brand spanking new to the list and have a quick question.

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, url='".addslashes($url)."', banner=$banner,caption='".addslashes($caption)."' WHERE imageID=$imageID";

...and $caption contains something like:

"Don't look"

...the data is chopped off at the single quote mark.

How, if not addslashes(), does one handle this?

Skip Evans
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

Reply via email to