jessica22 - 3:30 pm on Jul 15, 2013 (gmt 0)
Ok, I'll put it a different way.
I have a table named user_answers with columns named user_answer_id and user_name. Each user_name/user_answer_id has 25 rows per user. The user_answer_id can be different. What I'm trying to do is compare/match user Jake user_answer_id to user Betty user_answer_id. And get a count of those that match. I'll take the variables out in this example for easier interpretation.
$results = mysql_query("SELECT COUNT (*) `user_answer_id` FROM `user_answers` WHERE `user_name` = 'Jake' LIKE (SELECT `user_answer_id` FROM `user_answers` WHERE `user_name` = 'Betty')")
I tried substituting LIKE with IN.