#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2000
    Posts
    15
    Rep Power
    0
    Please could somebody help with this little problem. I use the following query

    $query = "select ID,make,model,type,engine,year,yearletter,colour,doors,status,price,city,county from cars where (make = '$make' and model = '$model' and county = '$county' and price <= '$price')";

    Now this works fine but some people have said that it would be better if there was a option to search using "any county" Could I add an option to the county drop down menu in my search form saying "Any" and then use a wildcard ? in the value section.
  2. #2
  3. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2000
    Posts
    20
    Rep Power
    0
    I believe if they select "any", you could just remove the "and country='$country'" clause. In effect you would be not selecting on a country, therefore any country matches.

Similar Threads

  1. Newbie Question
    By Zabbala in forum C Programming
    Replies: 1
    Last Post: February 9th, 2004, 12:00 AM
  2. Newbie table creation question
    By andy collins in forum PostgreSQL Help
    Replies: 3
    Last Post: January 23rd, 2004, 02:27 PM
  3. ok super newbie question
    By SCerviche in forum Flash Help
    Replies: 5
    Last Post: January 11th, 2004, 02:29 PM
  4. newbie question
    By lottidah in forum .Net Development
    Replies: 2
    Last Post: December 8th, 2003, 02:11 PM
  5. newbie question on install
    By iwanaa in forum PHP Development
    Replies: 4
    Last Post: November 25th, 2003, 08:02 PM

IMN logo majestic logo threadwatch logo seochat tools logo