[RESOLVED] removing html tags from text in database

[middleman666]

hey people,

i have a database entry which is text formatted by html tags,
on a page on my site i just want to be able to readout the text from the database not including the html formatting.

is tere a simpler way of doing this instead of replacing every html tag with nothing?

thanks for any help.

[konrad]

 mysql_connect(HOST, USER, PASSWORD);
 mysql_select_db(DATABASE);
 $res = mysql_query('SELECT html FROM sometable');
 list($html) = mysql_fetch_array($res);
 $clearText = strip_tags($html);

[bradgrafelman]

In other words: use [man]strip_tags/man

[middleman666]

cheers, works a charm 😉