Submitting Long Query

[BulldogGC]

I'm trying to submit a long string of text with numerous ' characters in it. This causes the query submission to give off an error. Any of you know how to correct this?

[matt_4013]

Could you please post the code? There's not much we can do without seeing exactly what you're doing.

[BulldogGC]

It's not really related to the code specifically.
I'm sure someone here will understand the very generic problem ...

Say I've got a sentence in a textbox named "field01" (ignore the quotes)

"i've got a problem"

And when I try to submit that using

$sql = "insert into whatever (whatever) values ('$field01')";
odbc_exec($db,$sql)

I can SEE why it's causing the error ... the ' in "i've" is interupting the "'" in $sql but I need to know how to escape that.

[jpmoriarty]

use addslashes()

[matt_4013]

or mysql_escape_string()

[BulldogGC]

Thanks guys for the help. Just a heads up that none of the suggested functions worked but I clicked the addslashes() link and read some of the comments and I ended up using -- $escaped_string = ereg_replace("'","''",$string_with_single_quotes); -- and that worked.

[BulldogGC]

Thanks guys for the help. Just a heads up that none of the suggested functions worked but I clicked the addslashes() link and read some of the comments and I ended up using -- $escaped_string = ereg_replace("'","''",$string_with_single_quotes); -- and that worked.