title: Best method for storing quiz results in MySQL
body: <p>I'm trying to record test/quiz scores in a database. What's the best method to do this when there might be a lot of tests and users? </p>
  
  <p>These are some options I considered: should I create a new column for each quiz and row for users, or does this have its limitations? Might this be slow? Should i create a new row for each user &amp; quiz? Should I stick to my original 'user' database and encode it in text?</p>
  
  <p>Elaborating a little on the plan: JavaScript Quiz, submits score with AJAX, and a script sends it to the database. I'm new with php so i'm not sure about a good approach.</p>
  
  <p>Any help would be greatly appreciated :) this is for a school science fair</p>