To access the data from database when select the value in dropdown menu

[robin1983]

Hi to all, i m newer to this site and fresher in Ajax world. Actually i get a problem while accessing data from Database. I have a combo box in my pages. Actually i want to access data from the database and put in a form variable as soon as when i select the name in the combo box. For more details i m giving the code below..
this is my first pages: empAttedence.php

<table width="100%" cellpadding="2" cellspacing="1">
 
<form name="attendence" method="post" action="attendence.php">
<tr >
<td align="left" width="40%">
    Employee Name:
</td>
<td align="left">
<?php 
 
 
        $empDepartment = $_GET['empDepartment'];
 
        $sql1 = "SELECT * FROM employee WHERE empDepartment='$empDepartment'";
        $result = mysql_query($sql1) or die(mysql_error());
?>
    <select name="empFirstName">
<?php
        while($rows = mysql_fetch_array($result))
 
        {
?>
 
        <option value="<?php echo $rows['empFirstName']; ?>"><?php echo $rows['empFirstName']; ?></option>
 
<?php
        }
?>
</select>
<?php 
    $sql1 = "SELECT * FROM employee WHERE empDepartment='$empDepartment'";
    $result = mysql_query($sql1) or die(mysql_error());
    $rows = mysql_fetch_array($result) or die(mysql_error());
?>
<input type="hidden" value="<?php echo $rows['empId']; ?>" name="empId">
<input type="hidden" value="<?php echo $rows['empDepartment']; ?>" name="empDepartment">
<input type="hidden" value="<?php echo $rows['empLastName']; ?>" name="empLastName">
 
</td>
</tr>
<tr>
    <td align="left">Date:</td>
    <td align="left"><input type="text" value="<?php echo date("Y-m-d");?>" name="empAttendenceDate" size="10">&nbsp&nbsp(YYYY-MM-DD)</td>
</tr>
<tr>
    <td align="left">
        In-Time:
    </td>
    <td align="left">
        <input type="text" name="empInTime" size="10">&nbsp (9.30)
    </td>
</tr>
<tr>
    <td align="left">
        Out-Time:
    </td>
    <td align="left">
        <input type="text" name="empOutTime" size="10"> &nbsp(6.30)
    </td>
</tr>
<tr>
    <td></td>
    <td align="left"><input type="submit" value="Submit" name="submit">&nbsp&nbsp<input type="reset" value="Reset" name="reset"></td>
</tr>
 
</form>
</table></b>
Actually when I select the name in 
<select name="empFirstName">
<?php
        while($rows = mysql_fetch_array($result))
 
        {
?>
 
        <option value="<?php echo $rows['empFirstName']; ?>"><?php echo $rows['empFirstName']; ?></option>
 
<?php
        }
?>
</select>

the data in the row should access automatically through ajax. Plz if you know then please help as soon as possible. I want to pass the other data through other pages as hidden value. Thanking you and waiting for you reply

[acoder]

The PHP code that retrieves the data should be put in a separate file. This should then be called via AJAX. See an example.