> I want to find out which memberIDs have BOTH choice 2 AND choice 3.
> --> SELECT memberID from table where choice=2 AND choice = 3
> That won't work (0 results, of course, because no row has two choices,
> they're mutually exclusive)

Exactly, keep several rows for choices,

have two tables

members  choices
id              memberid
name        choice

for instance if somebody (member 21) chooses 2 and 3
there must be in the choices table

choiceid   memberid  choice
1                  21             2
2                  21             3

then your sql statement will work.

(* you might still add another field in case for instance there are several

Lennin Arriola

PHP Database 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]

Reply via email to