I have the following code (pasted below). My form is supposed to allow a user to choose at least two courses. When he clicks on the submit button, it should be able to send an email to the administrator indicating which courses have been selected and at the same time, the information keyed in the form should be captured into my mySQL. How can I implement that? Any ideas?
_________________________________________
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>Participants must pre-register a</title>
</head>
<body>
<form method="POST" action="../../curriculumnew.htm">
<table width="100%" border="0" cellpadding="2" cellspacing="2" class="NormalText" id="table24">
<tr bgcolor="#EEEEEE">
<td colspan="3" class="NiceSmallBold" style="font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 11px" bgcolor="#FFFFFF">
<table border="0" width="100%" id="table25" cellspacing="0" cellpadding="0">
<tr>
<td width="353" valign="top">
Participants must pre-register at this time for <STRONG>two electives </STRONG> - a morning elective and an afternoon elective.</td>
<td width="15" valign="top"> </td>
<td valign="top">
<b>Full Names:</b><br>
<span style="font-size: 9pt">
<input name="txtFullNames" type="text" maxlength="50" id="txtNome0" size="30" /></span>
<div>
<b>Company:</b><br>
<span style="font-size: 9pt">
<input name="txtCompany" type="text" maxlength="50" id="txtCognome0" size="30" /></span>
</div>
<div>
<b>Email:</b><br>
<span style="font-size: 9pt">
<input name="txtMail" type="text" maxlength="50" id="txtMail0" size="30" /></span>
</div>
<p> </td>
</tr>
</table>
</td>
</tr>
<tr bgcolor="#EEEEEE">
<td colspan="3" class="NiceSmallBold" style="font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 11px" bgcolor="#FFFFFF"> </td>
</tr>
<tr bgcolor="#EEEEEE">
<td colspan="3" class="NiceSmallBold" style="font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 11px">
</td>
</tr>
<tr bgcolor="#FAC88B">
<td bgcolor="#FAC88B" class="BlackBold" width="69%" align="center">
<p align="left">Course Name </td>
<td bgcolor="#FAC88B" width="19%" align="center">
<p align="center"><span style="font-weight: bold">
Instructor</span></td>
<td bgcolor="#FAC88B" width="9%" align="center">
<p align="center"><strong>
Select</strong></td>
</tr>
<tr bgcolor="#FAC88B">
<td bgcolor="#FAC88B" class="WhiteVerdanaBold" style="font-size: 11px" width="69%">
Mornings</td>
<td bgcolor="#FAC88B" width="19%" align="center"> </td>
<td bgcolor="#FAC88B" width="9%"> </td>
</tr>
<tr bgcolor="#FDE9D0">
<td bgcolor="#FDE9D0" width="69%" valign="top"><span style="font-size: 11px">
1.
Financial Management (Note: This is a two week â
mornings only - course)</span></td>
<td bgcolor="#FDE9D0" width="19%" valign="top" align="center"><span style="font-size: 11px">
Furany Kadry </span></td>
<td bgcolor="#FDE9D0" width="9%" valign="top" align="center">
<input type="checkbox" name="chkFinmanagement" value="ON"></td>
</tr>
<tr bgcolor="#FDE9D0">
<td bgcolor="#FDE9D0" width="69%" height="24" valign="top"><span style="font-size: 11px">
2.
Product Marketing
</span></td>
<td bgcolor="#FDE9D0" width="19%" height="24" valign="top" align="center"><span style="font-size: 11px">
Gerald Macharia </span></td>
<td bgcolor="#FDE9D0" width="9%" height="24" valign="top" align="center">
<input type="checkbox" name="chkProdmarketing" value="ON"></td>
</tr>
<tr bgcolor="#FDE9D0">
<td bgcolor="#FDE9D0" width="69%" valign="top"><span style="font-size: 11px">
3.
Loan
Portfolio Audit Toolkit</span></td>
<td bgcolor="#FDE9D0" width="19%" valign="top" align="center"><span style="font-size: 11px">
Ramesh
Arunachalam </span></td>
<td bgcolor="#FDE9D0" width="9%" valign="top" align="center">
<input type="checkbox" name="chkLoanportfolio" value="ON"></td>
</tr>
<tr bgcolor="#FDE9D0">
<td bgcolor="#FDE9D0" width="69%" height="25" valign="top"><span style="font-size: 11px">
4.
Process Mapping </span></td>
<td bgcolor="#FDE9D0" width="19%" height="25" valign="top" align="center"><span style="font-size: 11px">
Graham A.N.
Wright </span></td>
<td bgcolor="#FDE9D0" width="9%" height="25" valign="top" align="center">
<input type="checkbox" name="chkProcessmapping" value="ON"></td>
</tr>
<tr bgcolor="#FAC88B">
<td bgcolor="#FAC88B" width="69%" valign="top"><span class="WhiteVerdanaBold" style="font-size: 11px">
Afternoons</span></td>
<td width="19%" valign="top" align="center"> </td>
<td width="9%" valign="top" align="center"> </td>
</tr>
<tr bgcolor="#FDE9D0">
<td bgcolor="#FDE9D0" width="69%" valign="top"><span style="font-size: 11px">
5.
Product Costing </span></td>
<td bgcolor="#FDE9D0" width="19%" valign="top" align="center"><span style="font-size: 11px">
Brigit Helms </span></td>
<td bgcolor="#FDE9D0" width="9%" valign="top" align="center">
<input type="checkbox" name="chkProductcosting" value="ON"></td>
</tr>
<tr bgcolor="#FDE9D0">
<td bgcolor="#FDE9D0" width="69%" valign="top"><span style="font-size: 11px">
6.
Strategic Marketing </span></td>
<td bgcolor="#FDE9D0" width="19%" valign="top" align="center"><span style="font-size: 11px">
James Mwangi </span></td>
<td bgcolor="#FDE9D0" width="9%" valign="top" align="center">
<input type="checkbox" name="chkStrategicmarketing" value="ON"></td>
</tr>
<tr bgcolor="#FDE9D0">
<td bgcolor="#FDE9D0" width="69%" valign="top"><span style="font-size: 11px">
7.
Risk Management </span></td>
<td bgcolor="#FDE9D0" width="19%" valign="top" align="center"><span style="font-size: 11px">
Trevor Mugwanga </span></td>
<td bgcolor="#FDE9D0" width="9%" valign="top" align="center">
<input type="checkbox" name="chkRiskmanagement" value="ON"></td>
</tr>
<tr bgcolor="#FDE9D0">
<td bgcolor="#FDE9D0" width="69%" valign="top"><span style="font-size: 11px">
8.
Pilot Testing </span></td>
<td bgcolor="#FDE9D0" width="19%" valign="top" align="center"><span style="font-size: 11px">
Henry Sempangi </span></td>
<td bgcolor="#FDE9D0" width="9%" valign="top" align="center">
<input type="checkbox" name="chkPilottesting" value="ON"></td>
</tr>
<tr bgcolor="#FAC88B">
<td width="69%" valign="top"> </td>
<td width="19%" valign="top"> </td>
<td width="9%" valign="top"> </td>
</tr>
</table>
<p align="center">
<input type="submit" value="Submit" name="B4"> <input type="reset" value="Reset" name="B3"></p>
</form>
</body>
</html>
Send/Insert data simultaneously
