Re: More problems with searching

On Thu, 1 Jul 2004 12:28:46 -0500, Shiloh Madsen <shiloh_madsen@nsc-support.com> wrote: > > 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' "; } Shouldn't that be OR? > > Ideas? > > Shiloh > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > !DSPAM:40e4480b265025655517531! > > -- DB_DataObject_FormBuilder - The database at your fingertips http://pear.php.net/package/DB_DataObject_FormBuilder paperCrane --Justin Patrin--