title: What would be the most efficient way of creating my MySQL database
body: <p>I'm thinking of doing something like...</p>
  
  <pre><code>Table Pants (20 entrees)  
  | ID | Item | Description | Price   
  
  Table Shirts (20 entrees)   
  | ID | Item | Description | Price   
  
  Table Socks (5 entrees)    
  | ID | Item | Description | Price  
  </code></pre>
  
  <p>Then I run a php foreach ID in $table, to populate the list on a page.</p>
  
  <p>So would this be an efficient way of doing this since some of my tables might not have many entrees? Or should I have all the entrees in one table and add an extra field for the different categories and find another way of populating my page via the new field? Or maybe a greater idea?</p>
  
  <p>Thanks for your time.</p>