connecting php to mysql database.

[princegifted]

<td><select name="jumpMenu" id="jumpMenu">
<option>Select Subject</option>
<option>Biology</option>
<option>Chemistry</option>
<option>Christian Religious Knowledge</option>
<option>Commerce</option>
<option>Economics</option>
<option>English Language</option>
<option>Government</option>
<option>Mathematics</option>
<option>Physics</option>
<option>Principle of Accounts</option>
<option>Agricultural Science</option>
</select>
<div align="center">
<label></label>
</div></td>
<td>&nbsp;</td>
<td><select name="jumpMenu2" id="jumpMenu2">
<option>Select Year</option>
<option><a href="Biologypassq2000.php">2000</a></option>
<option>2001</option>
<option>2002</option>
<option>2003</option>
<option>2004</option>
<option>2005</option>
<option>2006</option>
<option>2007</option>
<option>2008</option>
<option>2009</option>
<option>2010</option>
<option>2011</option>
<option>2012</option>
</select></td>

Above is my html Jumpmenus. I already attached a database, I want the database connected to the html so that when a visitor select the subject and the year S/he would be directed to the corresponding data.

I want the website to like an e-exam platform. Visitor should be able to view questions and select available option as well as view performance.

I believe there is a remedy to this because I already benefited from the awesome forum. I am a novice when it comes to php and mysql database.

It may be essential to know that the database is currently empty as I intend to upload the required data into the database after hosting the website.

Thanks in anticipation.