I'd try building it piece by piece if you do have too many combinations -
(I'm not promising efficiency, but I do something similar to this in one of
my programs and it works).
Have vars for each type of data:
$firstName = ;
$lastName = ; etc.
Then you can set each one based on the selection
=SELECT * FROM list WHERE $sWhere
}
*
- Original Message -
From: Leotta, Natalie (NCI/IMS) [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, March 05, 2002 8:50 AM
Subject: RE: [PHP-DB] Re: multiple select statements
I'd try building it piece