title: A practical way to organize MySQL database info?
body: <p>I'm wondering what is the best way to do this:</p>
  
  <ol>
  <li><p>Person submits review (name, email, webhost, domain hosted, ranking data [five numerical factors], etc.)</p></li>
  <li><p>PHP inserts that review into "SubmittedReviews" table</p></li>
  <li><p>I then oversee the submitted reviews in the back end, then submit the ones I want</p></li>
  </ol>
  
  <p>4 . PHP inserts that info into another table called "LiveReviews" (which has the same table structure as "SubmittedReviews")</p>
  
  <p>(OR, might be better to have PHP create a table for each host, with that hosts' reviews inside it, since there will be many hosts and I'm going to make a separate table to pre-calculate ranking data for my "top hosts" table on the site)</p>
  
  <p>So as I have PHP submit the reviews live (creating a new table [for each host] or just into the "LiveReviews" table) I will also submit the ranking data into another table, adding up all the ranking data for each host, so it is readily available and so I know which hosts are ranking highest.</p>
  
  <p>Or should I just use PHP to calculate the LiveReviews ranking data on the spot when I want to know which host is ranking best? Seeing as the front page will be loading this data often, doesn't seem it'd be good to calculate it every time. I'd rather have it calculated beforehand.</p>
  
  <p>So if I have this "ranking data" table, then it seems I should have tables for each host with all their reviews. Otherwise, it seems just having one large table (LiveReviews) is better.</p>
  
  <p>Hope this makes sense!</p>
  
  <p>What is the best way? I'm pretty new to MySQL.</p>