I'm working on a quiz type app. where each user answers 25 questions. Or possibly more. The answers are stored in the database as a 6 digit numerical value. I'm trying to compare user A's answers to user B. I've tried a mysql statement to sort the matches and return the values. Here's what I did.

This returned a #1242 mysql error stating that "subquery returns more than one row". After doing "some" reading, I find that route isn't going to work, at least the way I attempted it. Since trying that method I've altered the database so as not to have to make as many sub calls to get at the data. I'm currently working on finding a simple solution in php to sort and compare the results of two querys.So far nothing has worked. I could work with a rowcnt of matches. Anybody got any ideas?