Yo, thanks for all your help. But it isn't exactly what im looking for. Let's say you had a database with the following four columns...
-LastName -FirstName -Age -Weight ...and you wanted a page that would allow a user to search for one or more of these fields within the database. It would be easy if the user could only pick just one of the fields. But let's say that want to search only lastname and firstname, or maybe all four, or maybe just one. How could this be done? If I have code that looks like this... $query = "select * from table where lastname='$lastname' and firstname='$firstname' and age='$age' and weight='$weight'"; $result = mysql_query ($query); $num_results = mysql_num_rows($result); ...the $num_results is ALWAYS zero unless I typed in all four fields. Any help? Thanks!
