I have made a table called dtcompletion using mysql. It has three fields as shown below:
Studentid : (text box)
Dtestid : (Te xt box with options) (Has a combo or list box with a drop down menu)
Date : (text box)
In the IE browser in the Dtestid fiels, there should be a dropdown
menu for students to choose a level or class.
The code I have used below doesn't work.
<select name="select">
<?php
$db=robdatabase;
mysql_connect("localhost", "root", "peter1") or die( mysql_error()
mysql_select_db("$db");
$query = "SELECT Dtestid FROM 'dtcompletion'";
$result = mysql_query($query);
if (mysql_num_rows($result)) {
// loop through resulting rows, creating options
while ($row = mysql_fetch_row($result)) {
echo "<option value=\"".$row[0]."\">".$row[1]."</option>";
<option value="one">dty1(Year 1)</option>
<option value="two">dty2(Year 2)</option>
<option value="two">dty3(Year 3)</option>
<option value="two">dty4(Year 4)</option>
<option value="two">dty5(Year 5)</option>
<option value="two">dty6(Year 6)</option>
<option value="two">dty7(Form 1)</option>
<option value="two">dty8(Form 2)</option>
<option value="two">dty9(Form 3)</option>
<option value="two">dty10(Form 4)</option>
<option value="two">dty11(Form 5)</option>
}
} else
exit();
mysql_free_result($result);
?>
</select
