[bobdole]

Ok, I have a form with things like last name, first name, phone number, etc.

I need for my php script to search through my mysql database, but only if the user entered something into the given field. So if they only entered a first name it would only find the entries in the database with that first name. None of the fields are required.

How can I either search for all the entries with a first name, and then search those results for all the entries with the specified last name and so on, or just do one search where i check before hand to see if there are entries in each field and if there are not, simply put a wildcard in that field in the query.

Basically I would like to "build" the query as I check each field to see if anything is there. Any Ideas?

[zero]

I do'nt write english good.i post code the same proplem you
use:mysql,
table tt(id int primary key firstname char,lastname char,....,)
<?PHP
$str="select * from tt ";$check=mysql_length($str);
if($_post(firstname)<>"") {
mysql_length($str)=$check;
$str=$str."where (firstname=$_post(firstname))";
}
else $str=$str."and (firstname=$_post(firstname))" ;
if($_post(lastname)<>"") {
mysql_length($str)=$check;
$str=$str."where (lastname=$_post(lastname))";
}
else $str=$str."and (lastname=$_post(lastname))" ;

?>
the same for filed #