How can I preg_match info from database?

[pneudralics]

$name is from a form input.

I want to find out if $name is listed in badwords table. I keep getting my echo statement even though the name I input is a badword.

$badwordsq = "SELECT * FROM badwords";
if ($badwordsr = mysql_query($badwordsq)) {
	while ($badwordsrow = mysql_fetch_array ($badwordsr)) {
	$badword = $badwordsrow ['badword'];
	}
}

if (preg_match("/$badword/", "$name")) {
echo "name is badword";
}
else {
echo "name is good to go";
}

[devinemke]

if you just want to see if $name equals one of the bad words:

$result = mysql_query("SELECT COUNT(*) AS count FROM badwords WHERE badword = '$name'") or exit(mysql_error());
$row = mysql_fetch_assoc($result);
if ($row['count']) {echo $name . ' is a badword';} else {echo $name . ' is good to go';}

if you want to see if $name contains any of the bad words:

$badword_check = true;
$result = mysql_query('SELECT badword FROM badwords') or exit(mysql_error());
while ($row = mysql_fetch_assoc($result))
{
	if (strpos($name, $row['badword']) !== false)
	{
		$badword_check = false;
		break;
	}	
}

if ($badword_check) {echo $name . ' is good to go';} else {echo $name . ' is a badword';}