search query

Shadeless

Hi there,

i have the folowing search query

$query = "SELECT * FROM $tablename WHERE Date_Origin LIKE '%".$Date_Origin."%' OR Category LIKE '%".$Category."%' OR description LIKE '%".$description."%'
OR DY_nr LIKE '%".$DY_nr."%'
OR Software LIKE '%".$Software."%'
OR Software_version LIKE '%".$Software_version."%'
OR Firmware LIKE '%".$Firmware."%'
OR Originator LIKE '%".$Originator."%'
OR Keywords LIKE '%".$Keywords."%'
OR Answer_keywords LIKE '%".$Anser_keywords."%'";

Now when i apply this search it will return all content, because when a variable is blank it will just show every content.

How can i make the blank variables not shown, so when some1 fills in the search form and wants to search for category and certain keywords,so how can i make it that it will only show content wich matches there 2 things?

Can this be done in the same query?

Thx in advance

With kind regards,

Shadeless

Lars_Berg

Exclude the criteria

$query = "SELECT * FROM $tablename WHERE 1=1 "
if ( $Date_Origin != "" ) {
   $query .= "or Date_Origin LIKE '%".$Date_Origin."%'"
}
// etc for the rest of the columns

Shadeless

okif i try just the first those few lines or more, i get an parse error. I probaly do something wrong.

this is the code for the search query so far. do i need to change the 1=1, i'm just so newbie 🙁


$host = "localhost";
$user = "root";
$password = "";
$pass = "";
$dbname = "knowledgebase";
$tablename = "information";
$link = mysql_connect($host, $user, $password);


    $query = "SELECT * FROM $tablename WHERE 1=1 "

    if  ( $Date_Origin != "" ) {
           $query .= "or Date_Origin LIKE '%".$Date_Origin."%'"
      }
    if   ( $Category != "" ) {
           $query .= "or Category LIKE '%".$Category."%'"
      }




    $result = mysql_connect($host, $user, $pass);

$result = mysql_db_query ($dbname, $query, $link);

$num=mysql_numrows($result);

mysql_close($link);