Howdy all! I've built a page in Dreamweaver MX that uses PHP for scripting. I can get data out of my mysql database but I need to be able to search for wildcards. currently it only matches 100% exact queries. Below is the code that is at the beggining of the PHP page. ----------- $varSort_search1 = "%"; if (isset($HTTP_POST_VARS["Sort"])) { $varSort_search1 = (get_magic_quotes_gpc()) ? $HTTP_POST_VARS["Sort"] : addslashes($HTTP_POST_VARS["Sort"]); } $varText_search1 = "%"; if (isset($HTTP_POST_VARS["Text"])) { $varText_search1 = (get_magic_quotes_gpc()) ? $HTTP_POST_VARS["Text"] : addslashes($HTTP_POST_VARS["Text"]); } mysql_select_db($database_CATCH, $CATCH); $query_search1 = sprintf("SELECT * FROM secureworks WHERE %s LIKE '%s'", $varSort_search1,$varText_search1); $search1 = mysql_query($query_search1, $CATCH) or die(mysql_error()); $row_search1 = mysql_fetch_assoc($search1); $totalRows_search1 = mysql_num_rows($search1);
------------- Does anyone have any ideas? Thanks, John Cole, TCISA -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php