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??

[Anon]

first of all, do you want to store them as a blob, TEXT might be more appropriate...

i would also recommend stripping the html before the post is added to the database. this will use less space in the database, and not require the stripping each time the post is displayed.

to strip tags, use the php function strip_tags()

-paul
http://xhawk.net