Programming Forums - View Single Post

big_k105 · Mar 26th, 2008, 2:39 PM

Ok, so atleast now you know there is a problem when sending your query. might want to check your SQL statement.

Change this:

 php Syntax (Toggle Plain Text) 
#
//Now we search for our search term, in the field the user specified
#
$data = mysql_query("SELECT * FROM users WHERE upper($field) LIKE'%$find%'");
#
//Now we search for our search term, in the field the user specified
#
$data = mysql_query("SELECT * FROM users WHERE upper($field) LIKE'%$find%'");

to:

 php Syntax (Toggle Plain Text) 
//Now we search for our search term, in the field the user specified
$sql = "SELECT * FROM users WHERE upper($field) LIKE'%$find%'";
echo $sql;
$data = mysql_query($sql) or die(mysql_error());
//Now we search for our search term, in the field the user specified
$sql = "SELECT * FROM users WHERE upper($field) LIKE'%$find%'";
echo $sql;
$data = mysql_query($sql) or die(mysql_error());

This way you can see exactly what is being sent to the database.

Mar 26th, 2008, 2:39 PM	#7
big_k105 PFO Founder Join Date: Mar 2004 Location: Fargo, ND Posts: 1,603 Rep Power: 10	Re: Simple PHP Search Script Ok, so atleast now you know there is a problem when sending your query. might want to check your SQL statement. Change this: php Syntax (Toggle Plain Text) # //Now we search for our search term, in the field the user specified # $data = mysql_query("SELECT * FROM users WHERE upper($field) LIKE'%$find%'"); # //Now we search for our search term, in the field the user specified # $data = mysql_query("SELECT * FROM users WHERE upper($field) LIKE'%$find%'"); to: php Syntax (Toggle Plain Text) //Now we search for our search term, in the field the user specified $sql = "SELECT * FROM users WHERE upper($field) LIKE'%$find%'"; echo $sql; $data = mysql_query($sql) or die(mysql_error()); //Now we search for our search term, in the field the user specified $sql = "SELECT * FROM users WHERE upper($field) LIKE'%$find%'"; echo $sql; $data = mysql_query($sql) or die(mysql_error()); This way you can see exactly what is being sent to the database. __________________ BIG K aka Kyle Programming Forums Kyle K Online Please do not PM or email me programming questions. Post them in the forums instead.