Programming Forums - View Single Post

big_k105 · Mar 26th, 2008, 3:31 PM

Look at line 49 of the code that you just posted.
Looks like this:

 php Syntax (Toggle Plain Text) 
$data = mysql_query("SELECT * FROM users WHERE upper($field) LIKE '%$find%'") or  die(mysql_error());
$data = mysql_query("SELECT * FROM users WHERE upper($field) LIKE '%$find%'") or  die(mysql_error());

should be:

 php Syntax (Toggle Plain Text) 
$data = mysql_query($sql) or die(mysql_error());
$data = mysql_query($sql) or die(mysql_error());

Right now you aren't using the $sql variable that you used to change the sql statement.

Mar 26th, 2008, 3:31 PM	#12
big_k105 PFO Founder Join Date: Mar 2004 Location: Fargo, ND Posts: 1,602 Rep Power: 10	Re: Simple PHP Search Script Look at line 49 of the code that you just posted. Looks like this: php Syntax (Toggle Plain Text) $data = mysql_query("SELECT * FROM users WHERE upper($field) LIKE '%$find%'") or die(mysql_error()); $data = mysql_query("SELECT * FROM users WHERE upper($field) LIKE '%$find%'") or die(mysql_error()); should be: php Syntax (Toggle Plain Text) $data = mysql_query($sql) or die(mysql_error()); $data = mysql_query($sql) or die(mysql_error()); Right now you aren't using the $sql variable that you used to change the sql statement. __________________ BIG K aka Kyle Programming Forums Kyle K Online Please do not PM or email me programming questions. Post them in the forums instead.