More problems with searching

From: Date: Thu, 01 Jul 2004 17:28:46 +0000
Subject: More problems with searching
References: 1 2  Groups: php.db 
Request: Send a blank email to php-db+get-35081@lists.php.net to get a copy of this message
After the very kind help i was given last night I have the query being built right, however the query does not work. Just to refresh, the gentlemen who had helped me suggested creation of a query that looks like: SELECT * FROM table1 where 1 or cat or dog...and so forth. Now, this query is building fine, but the where 1 is causing it to return rows even if it has none of the search terms. When i run it in sql without the where 1 it works as it should, but with that, i get all rows returned. Is there a way i can reword this query or am I doing something wrong? this was Mr Holmes's solution (in part): $query = "SELECT * FROM keyword WHERE 1 " $words = explode(' ',$_GET['search_text']); foreach($words as $word) { $query .= " AND keyword = '$word' "; } Ideas? Shiloh

« previous php.db (#35081) next »