dkcp
01-23-2006, 08:23 PM
I would like to extract and compare data from 6 identical multiple choice polls. Same question and options in every poll. What I want to know is who voted and if they ever voted for the exact same option in one of the polls.
I've been trying to write this question myself but my problem is I don't know MYSQL well enough. This is a one time thing I need to do and will only be run as a SQL query in phpMyadmin. It would be helpfull if the output was in the form:
[username] voted for option [nr] [x] times.
I'm hoping someone with good knowledge of VB's DB structute can help me hammer out something.
Regards,
Dan
I've been trying to write this question myself but my problem is I don't know MYSQL well enough. This is a one time thing I need to do and will only be run as a SQL query in phpMyadmin. It would be helpfull if the output was in the form:
[username] voted for option [nr] [x] times.
I'm hoping someone with good knowledge of VB's DB structute can help me hammer out something.
Regards,
Dan