Page 1 of 1

---SOLVED---Search Multiple SQL Fields

Posted: Sat Oct 04, 2008 11:31 pm
by chopper_pc
I have a simple search scrpt that is working searching one field in a SQL database that I want to use in another script to search multiple fields for the search term. This is the code used to specify the search field:

Code: Select all

// Build SQL Query  
$query = "select * from BOL where name like \"%$trimmed%\"  
  order by name"; // EDIT HERE and specify your table and field names for the SQL query
 
 $numresults=mysql_query($query);
 $numrows=mysql_num_rows($numresults);
 
where "name" is what would be the syntax to add say a field called "name2" as well. I even tried a wild card but I received this error

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/results_bol.php on line 44
Any suggestions greatly appreciated.

Re: Search Multiple SQL Fields

Posted: Sun Oct 05, 2008 1:02 am
by pcoder
Replace your query with:

Code: Select all

 
$query = "select * from BOL where name like '%".$trimmed."%'  
   order by name";
 
It works.. 8)

Re: ---SOLVED---Search Multiple SQL Fields

Posted: Sun Oct 05, 2008 2:07 pm
by chopper_pc
// all posibilities
$query = "select * from BOL where ".
"column1 like '%$trimmed%' ".
"or column2 like '%$trimmed%' ".
"or column3 like '%$trimmed%' ".
"or column4 like '%$trimmed%' ".
"or column5 like '%$trimmed%' ".
"or column6 like '%$trimmed%' ".
"or column7 like '%$trimmed%' ".
"or column8 like '%$trimmed%' ".
"order by name";
Works like a charm, just change "columnX" to your field names

Re: ---SOLVED---Search Multiple SQL Fields

Posted: Sun Oct 05, 2008 3:29 pm
by VladSun
Or use a MySQL FULL TEXT search ...