On Thu, 1 Jul 2004 12:28:46 -0500, Shiloh Madsen
<[EMAIL PROTECTED]> 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--

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to