<?php>

	$conn = odbc_connect("mimersql", "MIMER_STORE", "GoodiesRUs");
	
	if(!$conn) {
		odbc_errormsg();
	} else
	{
		echo ( "<h3><font color=blue>Searched for string '" . $_REQUEST['stext'] . "' in table PRODUCTS. Result: <br><br></h3>" );

		$query = 'SELECT * FROM MIMER_STORE.PRODUCTS WHERE PRODUCT LIKE \'%' . $_REQUEST['stext'] . '%\'';

		$q = odbc_do($conn, $query);
		odbc_result_all($q, "border=1");
		odbc_close($conn);
	}
?>