Re: Another question - not exactly what i was looking for

construct your query like $query = "select * from table where "; lastname='$lastname' and > firstname='$firstname' and age='$age' and weight='$weight'"; if (isset($lastname) and $lastname !="") then $query.=" lastname=$lastname "; if (isset($firstname) and $firstname !="") then $query.=" and firstname=$firstname "; and so on....... You may need to do some more checking like if there already been a field selected earlier if so then add "AND " before the current field else don't add the "AND ". Hope that helps. ----- Original Message ----- From: "Phil Schwarzmann" <pschwar@jhmi.edu> To: <email@cczona.com>; <pricee@hhbrown.com>; <php-general@lists.php.net> Sent: Tuesday, January 15, 2002 3:53 PM Subject: [PHP] Another question - not exactly what i was looking for > 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! >