Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2004071

Re: [PHP-DB] More problems with searching From: Pablo M. Rivas (pmrivas01 <email protected>)
Date: 07/01/04

Hello Shiloh,

Ideas?... forget the " 1 "

$query = "Select * from keyword where ";
$words = explode(' ',$_GET['search_text']);
foreach($words as $word)
  { $query .= " keyword = '$word' and "; }
$query=substr($query,-4);

or...

$query = "Select * from keyword where ";
$words = explode(' ',$_GET['search_text']);
$andconde=0;
foreach($words as $word)
  { $query .= ($andcode++) ? " and keyword = '$word'" : " keyword = '$word'"; }

or...

$words = explode(' ',$_GET['search_text']);
$query = "Select * from keyword where keyword = '" . array_shift($words) . "'";
foreach($words as $word)
  { $query .= " and keyword = '$word'"; }

SM> After the very kind help i was given last night I have the query being built
SM> right, however the query does not work. Just to refresh, the gentlemen who
SM> had helped me suggested creation of a query that looks like:

SM> SELECT * FROM table1 where 1 or cat or dog...and so forth. Now, this query
SM> is building fine, but the where 1 is causing it to return rows even if it
SM> has none of the search terms. When i run it in sql without the where 1 it
SM> works as it should, but with that, i get all rows returned. Is there a way i
SM> can reword this query or am I doing something wrong?

SM> this was Mr Holmes's solution (in part):
SM> $query = "SELECT * FROM keyword WHERE 1 "
SM> $words = explode(' ',$_GET['search_text']);
SM> foreach($words as $word)
SM> { $query .= " AND keyword = '$word' "; }

SM> Ideas?

SM> Shiloh 

-- 
Best regards,
 Pablo

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