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 #