Multiple Field Search Form

DRTechie

ok here's the newbie with another question....

I have a search form with about 15 different search fields. I would like to be able to search the for any field that has been filled in. The information I am searching is located in three tables which I have posted below. If anyone has a piece of code or can give me an idea of how to do this I would really appreciate it..."keep it simple stupid".

TABLE site
Fields (site_id, sitename, address, state, city, zip, status, setup)

Table circuit
Fields (ckt_id, loopback, remote, carrier, core, solution, spids)

Table site_circuit
Fields (rel_id, site_id, ckt_id)

leatherback

Hi,

While running the risk of writing this for nothing.. Let's give it a go.

you haev submitted your form, and you want to query the data.
I think you have a field for each colum to be searched? (Consider the option of using one or two input field to set the tekst to search for, with a dropdownbox which sets the fields to search..)

Else use something along those lines: (this is not the most elegant solution, but would certainly work!):

$query = "select * from table1 where ";

if (!empty($country))
{
if (!isset($NotFirst))
{
$NotFirst = 1;
$query .= 'and country = $country";
}
else
{
$query .= ' country = $country";
}
}

DRTechie

will that work if I want to get the sitename by searching the ckt_id? This would require the use of the "site_circuit" table so I am just wondering if it will search through all the tables.

leatherback

Hi,

first of all, I'd suggest to have a look at the select statement as described in www.mysql.org.

But yes. You'd have to put the tablenames in the select query. The post I gave was to give you a start-off point, and not the full query.

so it would start off with:

"Select * from site, circuit, site_circuit where ckt_id = $id"

Nice of this:

You can leave ouyt checking for the first set of queries: You can just continue with:
if (!empty($country))
{
$query .= 'and country = $country";
}

if(!empty($State)
{
$query .= ' State = $State";
}

Sorry for the confusion.