code not updating records...errr

[drewbie]

hey guys, lemme know that im an idiot here. i cant see why the records arent being stripped of <br />, they remain untouched.
thanks for any help

<?
include "common_db.inc";
$link_id = db_connect($default_dbname);
$query = mysql_query("SELECT CCID, comment FROM comments_calls", $link_id);
while ($result = mysql_fetch_array($query))
{
   if ($comment = str_replace('<br />', '', $result[comment]))
   {
         echo "found!";
         $query2 = mysql_query("UPDATE current_calls SET comment='$comment' WHERE CCID='$result[CCID]'", $link_id);
   }
   else
   {
      echo "not found!";
   }
}
?>

[Paulus_Magnus]

Do you mean $result['comment']?

[drewbie]

no, i always put query variables without quotes, but ill start doing them with quotes

[Paulus_Magnus]

current_calls or comments_calls?

You query comments_calls but update current_calls, is that right? You're also searching for <br /> but you may need to search for <br> and <BR /> and <BR> unless you know that they will always be <br />.

Also, does your script say it found some of them?

I'd also think you'd need some { } around your $result['CCID'] in your UPDATE query to stop the parser choking.

[drewbie]

ha! im a fuckin idiot, yes current_calls, thank you much