HTML number of rows variables on MySQL column value

[sn0zb0z]

I'm trying to figure out how to make a query that sets the rows (number of weeks) depending on the number of weeks the instructor wants the clinical to go, this value is stored in a Mysql table called clinical with a column name weeks (int). Right now in my HTML I have just pasted 4 rows to get the look down. I realize I will need to make a connection to the db before this code\[code\]<table width="1000" border="1"><tr> <td colspan="8" style="background-color:#1589FF;text-align:center;"> <h1>Rating for the Week</h1> </td><tr> <th>Week</th> <th>Faculty Signature</th> <th>Rating for the Week <br> S+/S/NI/U</th> <th>Student Signature</th> <th>Rating for the Week <br> S+/S/NI/U</th></tr> <tr> <tr ALIGN="CENTER"> <td>1</td> <td><form><input type = "submit" /></form></td> <td><select> <option value="http://stackoverflow.com/questions/15750704/S+">S+</option> <option value="http://stackoverflow.com/questions/15750704/S">S</option> <option value="http://stackoverflow.com/questions/15750704/NI">NI</option> <option value="http://stackoverflow.com/questions/15750704/U">U</option> </select></td> <td><form><input type = "submit" /></form></td> <td><select> <option value="http://stackoverflow.com/questions/15750704/S+">S+</option> <option value="http://stackoverflow.com/questions/15750704/S">S</option> <option value="http://stackoverflow.com/questions/15750704/NI">NI</option> <option value="http://stackoverflow.com/questions/15750704/U">U</option> </select></td></tr> <tr> <tr ALIGN="CENTER"> <td>2</td> <td><form><input type = "submit" /></form></td> <td><select> <option value="http://stackoverflow.com/questions/15750704/S+">S+</option> <option value="http://stackoverflow.com/questions/15750704/S">S</option> <option value="http://stackoverflow.com/questions/15750704/NI">NI</option> <option value="http://stackoverflow.com/questions/15750704/U">U</option> </select></td> <td><form><input type = "submit" /></form></td> <td><select> <option value="http://stackoverflow.com/questions/15750704/S+">S+</option> <option value="http://stackoverflow.com/questions/15750704/S">S</option> <option value="http://stackoverflow.com/questions/15750704/NI">NI</option> <option value="http://stackoverflow.com/questions/15750704/U">U</option> </select></td></tr> <tr> <tr ALIGN="CENTER"> <td>3</td> <td><form><input type = "submit" /></form></td> <td><select> <option value="http://stackoverflow.com/questions/15750704/S+">S+</option> <option value="http://stackoverflow.com/questions/15750704/S">S</option> <option value="http://stackoverflow.com/questions/15750704/NI">NI</option> <option value="http://stackoverflow.com/questions/15750704/U">U</option> </select></td> <td><form><input type = "submit" /></form></td> <td><select> <option value="http://stackoverflow.com/questions/15750704/S+">S+</option> <option value="http://stackoverflow.com/questions/15750704/S">S</option> <option value="http://stackoverflow.com/questions/15750704/NI">NI</option> <option value="http://stackoverflow.com/questions/15750704/U">U</option> </select></td></tr><tr> <tr ALIGN="CENTER"> <td>4</td> <td><form><input type = "submit" /></form></td> <td><select> <option value="http://stackoverflow.com/questions/15750704/S+">S+</option> <option value="http://stackoverflow.com/questions/15750704/S">S</option> <option value="http://stackoverflow.com/questions/15750704/NI">NI</option> <option value="http://stackoverflow.com/questions/15750704/U">U</option> </select></td> <td><form><input type = "submit" /></form></td> <td><select> <option value="http://stackoverflow.com/questions/15750704/S+">S+</option> <option value="http://stackoverflow.com/questions/15750704/S">S</option> <option value="http://stackoverflow.com/questions/15750704/NI">NI</option> <option value="http://stackoverflow.com/questions/15750704/U">U</option> </select></td></tr><tr> <td colspan="8" style="background-color:#1589FF;text-align:center;"> <b> The student must pass the clinical component of the course which is ted on a pass/fail basis.<br> A clinical failure results in a grade of F for the course.<b> </td></tr> </table> </body> </html>\[/code\]