title: PHP mysql dynamic table (attendance sheet)
body: <p>I have 3 tables in my database:</p>
  
  <ul>
  <li>students </li>
  <li>courses</li>
  <li>attendance</li>
  </ul>
  
  <p>The first 2 tables have 2 fields (id, name) and the third has: corseID, studID, attDate and attStatus where attStatus is either present or absent</p>
  
  <p>What I need is this: a dynamic table with the following properties :</p>
  
  <ul>
  <li>the first column should be titled "Name" populated with student names from the student's table(done)</li>
  <li>the first row should be populated with the dates from the attDate field in the attendance table (done)</li>
  <li>the rest of the cells in between the above mentioned column and  row should have the attendance status pulled from the attStatus field in the attendance table giving the student name and attendance date</li>
  </ul>
  
  <p>Please provide a walk-through of how to tackle this problem (the more details, the better).</p>