replacing whitespace

[JD_]

i have a field on my database called cfax i want any whitespace to be removed from all the records.

so far i got somethign like

<? require ("db.php");
 $propquery = "SELECT * FROM products where cfax = 'cfax'";
    $propresult = mysql_query ($propquery) or die('SQL Query Failed');
	    while ($row = mysql_fetch_assoc ($propresult))
 { $myvar = str_replace(" ", "", $myvar);
 }
?>

i know that isnt correct though..?

[Merve]

It's just fine.