Quiz

First, thank you, Tim for all the work you've put into this quiz module. I use the quiz more than I do any other part of Moodle.

I'm getting up to speed with things and trying to learn a bit of PHP and MySQL and the like to facilitate what I want to accomplish. My big question (for now) is this:

How can I query the database very quickly for questions (database field mdl_question) that have a certain name and return the id of that question? I know that this must be pretty easy to search for one question, but I need to do this for a lot of words at once (e.g., 50 word) and return all id's. I would then take the question id's and plug them manually into a quiz.

For example, I would love to do this:

1. I need a vocab quiz consisting of 50 words. For example:

unshorn
racking
stowing
fray
surging
vaulting
pawnbroker
warily
ravishingly
hideous

I would like to have a query to find all the mdl_questions for those vocab questions. (The name of the mdl_question is the question I seek. For example, the vocab question for unshorn has the name "unshorn".) The query would then return the id of those questions. For example, 61,2217,1421,1214,217 and so on. I would then plug in those ids into the quiz. Of course, if there's an easier way, I'd love to know.

I realize that this may be fairly complicated (well, at least for me), but if you could point me in the right direction, I'd greatly appreciate it. Do I need to make a form? Or can I just use a query?

Thank you very much for everything.