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