Alright, I like to think I'm relatively competent with MySql, but I need a guru's help with this one as after hours of fooling with it the only thing I've joined is my head to my ass. Here's the deal.
I have two tables: Records: member_id - int question_id - int Questions: id - int There are several questions in the 'questions' table, each with a unique id. Every time a person answers a question, it gets logged into the 'records' table with their personal member_id along with the question id (question_id). Simple really. I'm looking to select a random id from the questions table, given that there is no record of the user already answering that question. I've tried a million things with no luck, from the simplest to the most complicated.and yet it seems like an easy solution. I'm convinced some part of the query has to contain where 'column is null'.other than that I'm clueless. Thanks so much for the help!! GG
