I have tried something like this :
Code: Select all
$sql = "SELECT * from programmes";
$result = mysql_query($sql, $conn) or die(mysql_error());
while ($row = mysql_fetch_array($result)){
$progs = $row['programe_name'];
$sems = $row['no_of_semesters'];
$form = "<body>
<form action='studentregistrationform.php' method='post' enctype='multipart/form-data'>
<td>Programe:</td>
<td><select name='programe'>
<option value='$progs'>$progs</option>
</select></td>
</tr>
<tr>
<td>Semester:</td>
<td><select name='semester'>
<option value='$sems'>$sems</option>
</select></td>
</table></form>";
}