Pull blob out of DB as text, not HTML

[Anon]

Hello,

I'm working on a forum script, which posts info to a MySQL database and gets it out.

However, on the forum itself I want to display the messages - stored in a blob - and get them out as text, so HTML tags are disregarded.

Is that possible??

[petrb]

You are not going to get any help if you cross-post. RTFM:

string strip_tags (string str [, string allowable_tags])

--ph

[lawnmowerman]

If I understand your situation correctly, you want to strip all HTML tags from the data stored in the blob. You can do this before you update/insert the data into the database (recommended if the tags will never be needed) or when you pull it out.

Either way, strip_tags() is probably the function you're looking for.

Hope this helps!

-Rich

[Anon]

BTW: use TEXT instead of BLOB: BLOB is for binary stuff. (BLOB can be used for text, but MySQL made a special TEXT-type field so why not use it??)