Help selecting from more then 1 field

Discussion in 'Databases' started by edual200, May 25, 2008.

0
  1. #1
    trying to select from a few fields but cant get it to work, im sure im just doing something wrong...


    $query = "select * from companies WHERE state = '$state' AND city = '$city' AND category like '%$query%' OR subcategory like '%$query%' OR businessname like '%$query%'";

    The bold section is where the problem is as if i dont use those it works fine

    Thanks
     
    edual200, May 25, 2008 IP
  2. Kuldeep1952

    Kuldeep1952 Active Member

    Messages:
    290
    Likes Received:
    18
    Best Answers:
    0
    Trophy Points:
    60
    #2
    You should enclose the OR searches with parenthesis.
    The query seems to be recursive. You are not using $category,
    $subcategory and $businessname.

    Try this:

    $query = "
    select * from companies
    WHERE state = '$state' AND
    city = '$city' AND
    (category like '%$category%' OR
    subcategory like '%$subcategory%' OR
    businessname like '%$businessname%' )";
     
    Kuldeep1952, May 25, 2008 IP
  3. eopeter

    eopeter Peon

    Messages:
    33
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Try this:

    $query = "
    select * from companies
    WHERE (state = '$state' AND
    city = '$city' AND
    (category like '%$category%' OR
    subcategory like '%$subcategory%' OR
    businessname like '%$businessname%' ))";
     
    eopeter, May 26, 2008 IP