Mysql Query Problem

[Anon]

I'm working on a site with a form with checkboxes which queries a mysql database in the following way;

The basic structure allows users to query a database that has holiday information

place name
budget
(Hotel
Camping
Resort)
Location
(City
Rural
Cultural
Coastal)

I've created the Database and the query and all works fine through a form with checkboxes.

My query returns results of the palce name if you select a budget range (it's a less than $value query) and if you tick Hotel then every entry containing Hotel comes back. Ok that's fine but I need to say if Hotel and/or camping then bring back a result and then if City then just bring back a result for any entries that have either Hotel or Camping and is a City.

I just don't know how this query should be written. Basically the bracketed items in the above list are grouped together and then the next group needs to be queried once the first has been done.

It's not easy to explain and I've deliberatley not posted the full code but I can if anyone thinks they can help.

Regards

[Anon]

In general, MySql supports arbitrarily complex logical
expressions, so you can write queries of the form

 select * from table where (type = 'camping' or type = 'resort') and
&nbsp;&nbsp;&nbsp;(location = 'rural' or location = 'coastal') and price < 100

[Anon]

If you are asking how to build the query string from passed form data - i was working on something similar that had a form with multiple text fields that could be filed in or not. I hope it helps you .

$querystring = "";
$querytext = "Displaying Data ";

If (!empty($instrument))
{
$querystring = $querystring . " a.instrument='$instrument' and";
$querytext = $querytext . " for Instrument <b>$instrument</b> and ";
}

If (!empty($catagory))
{
$querystring = $querystring . " a.category='$catagory' and";
$querytext = $querytext . " in the Category <b>$catagory</b> and";

}

If (!empty($title))
{
$querystring = $querystring . " a.name like '%$title%' and";
$querytext = $querytext . " with <b>$title</b> in the name of the disk and";
}

$querystring = substr($querystring,0,strlen(chop($querystring))-3);
$querytext = substr($querytext,0,strlen(chop($querytext))-3);