$conn = odbc_connect("mimersql", "MIMER_STORE", "GoodiesRUs"); if(!$conn) { odbc_errormsg(); } else { echo ( "

Searched for string '" . $_REQUEST['stext'] . "' in table PRODUCTS. Result:

" ); $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); } ?>