comparing form to database

[adult_swim]

Im trying to:

1. create a form page in HTML

2. create a .php page that queries an ODBC database that I have, and compares info submitted

in the form to info in my database.

My question is how can i make the comparison between my form and my databse.

form.html---

<form action="process.php" method="get">
mlsnumber:
<input name="mlsnumber" type="text" />
<input name="" type="submit" />
</form>

process.php--- "this is what i have so far...

connect to a DSN "homep_props" with a user and password ""

$connect = odbc_connect("homep_props", "", "");

query the users table for *

$query = "SELECT * FROM props";

perform the query

$result = odbc_exec($connect, $query);

[bogu]

When u submit the form, u should select from DB the values that equal what u enter into the forms elements:

Ex.

$search = $_POST['txtSearch'];
$sql = "SELECT * FROM `table` ";
$sql.= "WHERE `description` LIKE '%{$search}%'";