exclude whitespace from mysql query

[goltoof]

Need to exclude whitespaces from mysql input.  When user inserts space accidentally, php needs to eliminate it, whether searching or updating the field.

<tr><td>Model# </td><td><input type="text" name="model" size="" /></td></tr>
<?php
$id = $_POST[''];
$model = $_POST['model'];
$query= "INSERT INTO product_specs (ID, model)
VALUES ('NULL', '".$model."')";
?>

 

Also need to exclude whitespaces from mysql query. 

<?php
$model=$_GET["model"];
$result = mysql_query("select * from product_specs where model ='$model'");
if ($row = mysql_fetch_object($result)) {
echo 'Model# '. $row->model . '<br />';
}
?>

 

I'm familiar with trim(), preg_replace() just unclear how to include in the script.

[WebStyles]

$model=str_replace(" ","",trim($_GET["model"]));