query using Dropdownlist operator

Dear sirs and madams.I have a table with thisese fields. ... name and ageNow i want to filter the records using age =, =please kindly throw hight on this or kindly send me sample codes for making forms and codes for filetering records

With regards

my codes are are as below

<form name="search" method="post" action="try_ac.php">

First name:
<Select NAME="field">

<option value="LIKE">LIKE</option>
<option value="LIKE %...%">LIKE %...%</option>
<option value="NOT LIKE">NOT LIKE</option>
<option value="=">=</option>
<option value="!=">!=</option>
<option value="REGEXP">REGEXP</option>
<option value="NOT REGEXP">NOT REGEXP</option>
<option value="= ''">= ''</option>
<option value="!= ''">!= ''</option>
<option value="IS NULL">IS NULL</option>

</select>

<input type="text" name="name">

<br>



Last name:
<Select NAME="field">

<option value="LIKE %...%">LIKE %...%</option>


</select>



<input type="text" name="name">

<br>




Pers's age:
<Select NAME="field">

<option value="=">=</option>
<option value="&gt;">&gt;</option>
<option value="&gt;=">&gt;=</option>
<option value="&lt;">&lt;</option>
<option value="&lt;=">&lt;=</option>

</select>

<input type="text" name="name">




<input type="hidden" name="searching" value="yes" />

<input type="submit" name="search" value="Search" />
</form>


?php
if ($_POST["searching"] =="yes")
{
echo"<h2>results</h2><p>";
if ($_POST["field"] =="")
{
echo"<p>you forgot to enter search term";
exit;
}

$db_host="127.0.0.1";
$db_user="root";
$db_password="";
$db_name="test";
$connection=@mysql_connect($db_host, $db_user, $db_password) or die("Error connecting to server");
$db=mysql_select_db($db_name,$connection) or die("Error connecting to database");

$field=$_POST["field"];
$find=strtoupper($_POST["name"]);
$find=strip_tags($find);
$find=trim($find);

if($field==="fname")
{
$data=mysql_query("SELECT * FROM users WHERE fname like '$find%'");

}
if($field==="lname")
{
$data=mysql_query("SELECT * FROM users WHERE lname like '$find%'");
}
if($field==="dz")
{
$data=mysql_query("SELECT * FROM users WHERE dz like '%$find%'");
}


if($field==="age"){

$data=mysql_query("SELECT * FROM users WHERE age > '$find'");

}
if($field==="age"){

$data=mysql_query("SELECT * FROM users WHERE age < '$find'");

}



while($result=mysql_fetch_array($data))

{


echo $result['fname'];
echo"";

echo"<br>";
echo $result['lname'];
echo"<br>";
echo $result['dz'];
echo"<br>";
echo $result['age'];

echo"<br>";
echo $result['datejoin'];
echo"<br>";
echo"<br>";

}
$anymatches=mysql_num_rows($data);
if ($anymatches==0)
{
echo "Sorry we cannot find entry that matches your search querry<br><br>";
}
echo"<b>Searched based on ".$field.": for string".$find;
}
?>

 

My html code is as below First name: LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP = '' != ''IS NULL
Last name: LIKE %...%
Pers's age: = > >= < <= ///////////////////PHP code as below