how 'bout something like
$query = 'select * from table_name where ';
$and = '';
if ($lastname != '') {
$query .= "lastname = $lastname";
$and = ' and ';
}
if ($firstname != '') {
$query .= $comma."firstname = $firstname;
$and = ' and ';
}
and so on
on 1/15/02 1:53 PM, Phil Schwarzmann at [EMAIL PROTECTED] wrote:
> 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!
>
-- mike cullerton michaelc at cullerton dot com
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
