Monday, 14 December 2015

Adding a column's value in a Listbox using php




<?php
$A = mysql_connect("LocalHost","root","") or die("Error in MYSQL Connection!");
mysql_select_db("attendencedb",$A) or die("Error in DataBase!");
$NA = mysql_query("SELECT concat(FirstName, ' ' , LastName) as Name FROM tblstudent") or die("Error in Selecting ID...!");
?>
<select name="dynamic_data">
<?php
$i=0;
while($row = mysql_fetch_array($NA)) {
?>
<option value="<?=$row["Name"];?>"><?=$row["Name"];?></option>
<?php
$i++;
}
?>
</select>
<?php
mysql_close($A);
?>

No comments:

Post a Comment