Tilted Forum Project Discussion Community - View Single Post

Outpour · 09-12-2004, 01:50 PM

So to do the actual query would you do seperate queries for each term?

PHP Code:


			
//Let $_GET['q'] be the search terms

$search = explode(" ",$_GET["q"]);

foreach ($search as $term) {

   $query = "SELECT DISTINCT * FROM table WHERE field LIKE '%$term%' OR field2 LIKE '$term%' OR field3 LIKE '%$term%'";

}

Obviously that itself won't work.. $query would be over written each time the foreach loops. How would you do a query on all the terms and combine them into one large array?

09-12-2004, 01:50 PM	#5 (permalink)
Outpour Upright	So to do the actual query would you do seperate queries for each term? PHP Code: `//Let $_GET['q'] be the search terms $search = explode(" ",$_GET["q"]); foreach ($search as $term) { $query = "SELECT DISTINCT * FROM table WHERE field LIKE '%$term%' OR field2 LIKE '$term%' OR field3 LIKE '%$term%'"; }` Obviously that itself won't work.. $query would be over written each time the foreach loops. How would you do a query on all the terms and combine them into one large array? __________________ Nihilism is the organic, reasoned response to artificial chaos, the intentional chaos manufactured by government, religion and mass-media.