preg_match mysql table

[MtPHP]

Hi someone gave me this

$sql = "SELECT words FROM profanity";
$res = mysql_query($sql);
while($row = mysql_fetch_array($res))
{
$word = $row['words'];
if(preg_match ("/b$wordb/i", $username))
$flagged = 1;
}
if($flagged == 1)
{
print 'some error text';
exit;
}

for my profanity filter. It is just returning no errors, not paying any attention to whether or not it actually finds the words. Anyone have any ideas?

[xblue]

This way you are trying to match: "b" followed but the keyword followed by another "b" (or did the backslashes get dropped again)?

try /\b$word\b/i

(\b is a word boundary)

[MtPHP]

That worked, thanks!