>Iím trying to figure out how to do a search trough a MySQL db using LIKE
>or = but the thing is that I have 3 select boxes from where to choose
>the search terms. Can I use something like a wildcard instead of making
>several IF statements like this?
>
>SELECT * FROM table_name WHERE col1 = value1 AND col2 = value2 AND col3
>= %
>
>% goes for an unselected select box (default value = %) in case the user
>doesnít want to make an *advanced* search, so it fetches all rows which
>does contains values 1 & 2.

Here is what I would do, if I was doing what I think you're doing, which I'm
not at all sure of...

<?php
  $query = "select col1, col2, ... from table_name where 1 = 1 ";
  if (isset($value1)){
    $query .= " and col1 = $value1 ";
  }
  if (isset($value2)){
    $query .= " and col2 = $value2 ";
  }
  if (isset($value3)){
    $query .= " and col3 = $value3 ";
  }
  mysql_query($query) or error_log(mysql_error());
?>

The where 1 = 1 technique is a sort of "yeast" to allow all the subsequent
parts to start with " and ..."

If you change to " OR ... " then you need " where 1 = 0 "

Think about it or work through an example to see why :-)

--
Like Music?  http://l-i-e.com/artists.htm
Off-Topic:  What is the moral equivalent of 'cat' in Windows?

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

Reply via email to