从特定员工的表中选择数据[关闭]

I try to select request data of specific employee but I don't get any thing. Pls help me.

this is the code of first page. I chose the employee from the list.

<select name="emp_id">
  <?php
  $emp_id = $_SESSION['emp_id'];
    $query= "SELECT emp_id FROM request";   
    $result = mysql_query($query);
if(!$result)
        {die("Query got problem").(mysql_error());}
    else  
    { 
while($row = mysql_fetch_assoc( $result )) {
    echo "<option>".$row['emp_id']."</option>";}
    echo "</select>";

}

?>

this is the code of second page

<?php
   $con=mysql_connect("localhost","root","");
   mysql_select_db("employee_transfare",$con);
$query="select employee.f_name, employee.emp_id, request.from request.to, request.description, request.date from employee,equest where employee.emp_id=$_POST[emp_id] and employee.emp_id= request.emp_id"  ;
        $result = mysql_query($query); 
    {
        echo "<table border='1'>";
        echo "<tr> <th>Employee Name</th><th>ID</th><th>Current Department</th> <th>Requested Department</th> <th>Reason</th> <th>date</th>  </tr>";
        while($row = mysql_fetch_array( $result )) {
        echo "<tr><td>"; 
        echo $row['f_name'];
        echo "</td><td>"; 
        echo $row['emp_id'];
        echo "</td><td>"; 
        echo $row['from'];
        echo "</td><td>"; 
        echo $row['to'];
        echo "</td><td>"; 
        echo $row['description'];
        echo "</td><td>";
         echo $row['date'];
        echo "</td></tr>"; 
    } 
    echo "</table>";
    } 

?>

first error I see:

echo "<option>".$row['emp_id']."</option>";

should be:

echo '<option value="'.$row['emp_id'].'">'.$row['emp_id'].'</option>';

next possible problem:

$query="select employee.f_name, employee.emp_id, request.from request.to, request.description, request.date from employee,equest where employee.emp_id=$_POST[emp_id] and employee.emp_id= request.emp_id"  ;

should be:

$query='select employee.f_name, employee.emp_id, request.from request.to, request.description, request.date
    from employee,request
    where employee.emp_id='.intval($_REQUEST['emp_id'], 10).' and employee.emp_id=request.emp_id';

just for debug errors you can also change:

$result = mysql_query($query);

to

$result = mysql_query($query) or die(mysql_error());