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
