HTML; Questions from a database

Question

I am trying to build a web application to help students memorize answers to test questions.

I have a mySQL database containing the questions, answers, categories, difficulty ratings and random numbers (for sorting the questions randomly).

What I need to do is allow the user to choose a category, then the app will display the questions ordered by difficulty and then randomly. Each question will be displayed for 10-15 seconds, then replaced by the answer. There will be Yes / No buttons so the student can indicate whether or not they've answered correctly (the app is purely for study purposes, so there is no incentive to cheat). The difficulty rating will be increased/decreased, and the random column updated with a new random number. Then the next question will be displayed.

I've got the webpage done, and displaying questions; I'm not sure how to proceed. Thank you for any assistance.

Answer 1

You need a server-side language to talk to MySQL and do logic, then display the data and throw it back to the client.

Answer 2

Look into PHP. You should be able to catch it up real quick and get going..