filter?

Anon

Hi I have a question about filtering

I have a form on my page with 7 fields. I want to make a search in a database according to the fields they entered. From 1 to 7. How can I make a efficient filtering? Do I really have to write an SQL command for every case? I hope not...

/swedee

Anon

I'm not sure I understand what you are trying to do here, but it sounds like OR'ing your conditions would do the trick.

select field1, field2, field3, . . . from table_name where field1='data1' OR field2='data2' OR . . .

Regards,
DLB

Anon

but if i do like that I only get the result from one of the fields no?

for example if the suer fill in 3 fields i want to perform the search so that the hits fit in on all the 3 fields and if they fill in 5 the hits has to contain of all five fields.

For example if the fields are

name
village
phone
fax
..
..
..

and they fill in name and phone and then clcik search the hits has to fulfill both criterias.

Thanks again

rodif_bl

ok you might want to do somethign like this
Quick and dirty... sorry

$query = "select * from table where";

if($name != null)
{
$query .= " name = $name";
$and = " and";
}
if($village != null)
{
$query .= " $and village = $village";
$and = " and";
}
if($phone!= null)
{
$query .= " $and phone = $phone";
$and = " and";
}

Anon

I am sorry I think it was a bit too dirty for me. I didn't get the point really. can that make a filtering sort of depending on how much info the user puts in?

Anon

$query = "select * from table where";
your Initial SQL querry

now, we check if the data was filled.
if it was, we add pieces to the querry, acording to what was filled.

if($name != null)
{
$query .= " name = '$name'";
$and = " and";
}

$query = "select from table where";
$query .= " name = $name";
is the same as
$query = "select from table where name = '$name'";
it´s not that hard