Help with SQL statement

Discussion in 'PHP' started by adamjblakey, Feb 21, 2008.

0
  1. #1
    Hi,

    What is the correct way to write this statement.

    "SELECT * FROM listings WHERE (category or category2 or category3) = '$cat' AND (subcategory or subcategory2 or subcategory3) = '$pagename' AND (location or location2 or location3) = '$region' AND type = 'Premium'"

    Cheers,
    Adam
     
    adamjblakey, Feb 21, 2008 IP
  2. HomeStart

    HomeStart Peon

    Messages:
    6
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    SELECT * FROM listings
    WHERE (category = '$cat' or category2 = '$cat' or category3 = '$cat')
    AND (subcategory = '$pagename' or subcategory2 = '$pagename' or subcategory3 = '$pagename')
    AND (location = '$region' or location2 = '$region' or location3 = '$region')
    AND type = 'Premium'
     
    HomeStart, Feb 21, 2008 IP
  3. adamjblakey

    adamjblakey Active Member

    Messages:
    1,121
    Likes Received:
    10
    Best Answers:
    0
    Trophy Points:
    80
    #3
    Thanks for that :)
     
    adamjblakey, Feb 21, 2008 IP