Mysql and quotation..HELP!!

[Anon]

Hi,
when I try to use a quote ' in a field (blob) that's to be added to mysql table

eg:
<textarea cols=75 rows=30 name="detail"></textarea>

it messes everything up, records wont get updated.. I guess ' confuses the script?

is there another way aroudn it? I tried to use 2 of the

eg: test'' test123

works, but not

test' test123

Anyone help?

Thanks

[mithril]

Yihung,

You've got two possible solutions here. I'm guesing that you're enclosing the blob text in single quotes with the sql statement string? You can either change the single quote to a double quote enclosure, or you can addslash the field:

$detail = addslashes($detail);

You're getting error's because mySQL is interpretting the single quote as a string termination char. By double piping the single quote, you are effectively addslashing it so that's why that worked for you. HTH,

Cheers,

Geoff A. Virgo

[Anon]

SWEEEEEEEEEEEEET!

Thanks!! 🙂

worked wonder.

[trellie]

Also.. a small note,

BLOBs are used in mysql to store binary data. They are not really suited to store text (although it still works!)

I suggest changing the field type from BLOB to TEXT.

[Anon]

binary data? could you explain what then is suited for blobs?

also, the field I use contains lots of html codes..

thanks

[mithril]

yihung,

A text field will still work with html code, it is after all only text🙂 Examples of binary data you might store in a BLOB field are images or audio files. Instead of storing a filesystem reference to those files, you could store the actual data (the wierd characters you see if you reveal source an image in Netscape). HTH,

Cheers,

Geoff A. Virgo

[Anon]

I see, Thanks a lot!