splitting up a mysql row

[scbmx]

this goes along with something i had asked before, about censoring words. Well i have that part working if i edit the source code for the "bad words", but i am trying to figure out how to split up the output of one row. so that i can have this

$message = eregi_replace($row[badwords],"<I>censored</I>",$word);

magically turn into this

$message = eregi_replace(poop,"<I>censored</I>",$word);
$message = eregi_replace(butt,"<I>censored</I>",$word);
$message = eregi_replace(bowlcut,"<I>censored</I>",$word);

So the row "badwords" has all the bad words i want censored in it. maybe im going the wrong way on this, any advice on how to do anything like this?

thanks ahead of time

[cgraz]

let me see if i understood correctly? You have a field in your db called badwords, and you want to create a dynamic list (like the three you showed) that generates automatically using the words in your bad words field?

$query = mysql_query("SELECT badwords FROM your_table");

$message = "";

// will create a variable message and continue adding onto that variable while there are badwords in the db

   while($a_row=mysql_fetch_array($query));
      $message .= eregi_replace($a_row[badwords],"<I>censored</I>",$word)\n;
   }

// will create an array for all the different bad words
$message = explode("\n", $message);

//you can call up these variables using $message['0'] $message['1'] and continue going. If there were 21 badwords found
// since this starts at 0, you can go up to $message['20'] 

Cgraz

[scbmx]

i can see where you are going with that, which is exactly what i want to do, but the problem is, i don't have a seperate table for bad words, i only have one row in the table. i dont know if this is possible, but i know it can be down with just textfiles. so its probably possible with mysql?

[cgraz]

It would work with either text files or mysql.