Untitled

<HTML>
<HEAD>
<TITLE>Hallgató felvitel </TITLE>
</HEAD>
<BODY>
<FORM ACTION="felvitel.php" ID="HFel">
<TABLE ALIGN="CENTER" WIDTH="600">
<TR>
<TD ALIGN="RIGHT">N&#233v:</TD>
<TD><INPUT TYPE="text" NAME="nev" MAXLENGTH="60"></TD><TD></TD>
</TR>
<TR>
<TD ALIGN="RIGHT">Neme:</TD>
<TD><INPUT TYPE="radio" NAME="ferfi">F&#233rfi:</TD>
<TD><INPUT TYPE="radio" NAME="no">N&#337:</TD>
</TR>
<TR>
<TD ALIGN="RIGHT">Osztály:</TD>
<TD>
<?PHP
$servername="172.16.3.254";
$username="root";
$password="";
$dbname="lammel";
$conn=mysqli_connect($servername,$username,$password,$dbname);
if(!$conn){
	die("Hibás kapcsolat:".mysqli_connect_error());
}
$sql="SELECT kezdeseve,vegzeseve FROM osztaly";
$result=mysqli_query($conn,$sql);
if(mysqli_num_rows($result)>0){
		echo "<SELECT NAME="kosztaly">";
	while($row=mysqli_fetch_assoc($result)){
		echo "<OPTIONS VALUE>".$row["kezdeseve"]."</TD><TD>".$row["nev"]."</TD><TD>".$row["ferfi"]."</OPTION>";
	}
	echo "</SELECT><TD>";
}else{
	echo "Az osztaly tabla ures";
}
mysqli_close($conn);
?>
</TD>
<TD>