> 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
-----------------------
                choiceid
id              memberid
name        choice
whatever

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
votaciones...)

Lennin Arriola
[EMAIL PROTECTED]


-- 
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