wildcard in SQL is %, so your query looks like:
$query_search1 = "SELECT * FROM secureworks WHERE $varSort_search1 LIKE
'%$varText_search1%'";
[EMAIL PROTECTED] wrote:
>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
