Dynamic population of drop down lists

[sha]

I have a mysql table which has two fields ‘epf'(like ID) and ‘Name’. I’m having a php script which has two dropdown lists for epf(values are obtained by querying the database) and name. when user selects an epf, corresponding name should appear in the second drop down list dynamically . this is the code i have tried so far by getting help from this site too. but, it’s not working as i expected. please help to solve this and thank you in advance.

require_once ‘includes/db_con.php’;

?>

;

-Select EPF-;
$query= “SELECT * FROM employee” or die (mysql_error());
$result= mysql_query($query);

while ($row=mysql_fetch_array($result))
{

echo “

$row[epf]“;
;
}
?>

$query2= “SELECT * FROM employee where epf=’$epf5′” or die (mysql_error());

$result2= mysql_query($query2);
while ($row2=mysql_fetch_array($result2))
{

echo “

“.$row2{name}.”“;

}?>

[Author]

Posts