<?phpinclude "connect.php";$query="select * from department";$rs=mysqli_query($db, $query);//execute SQL commandif($rs==false){//if SQL failecho "SQL error: ".mysqli_error($db);exit(0);}if(mysqli_num_rows($rs)==0){//if no recordecho "Sorry, no record fetched...<br>";}else{//ada rekodecho "<select name='dept'>\n";while ($rekod=mysqli_fetch_array($rs)){echo " <option value='".$rekod['DEPTNO']."'>";echo $rekod['DEPTNAME']."</option>\n";}echo "</select> \n";}?>
Comments
Post a Comment