Code: Select all
function Display_Employee_Details($employee_id){
$query = "Select * FROM employees WHERE employee_id = $employee_id";
$result = mysql_query($query);
echo $query;
if(!$result){
echo 'Error in Search for Results:'.mysql_error();
exit();
}
else{
//Get Results
global $last_name,$first_name,$email,$city,$street,$unit_
no,$province,$country,$postal_code,$birth_date, $telephone,$oasis;
$row = mysql_fetch_array($result);
$last_name = $row['last_name'];
$first_name = $row['first_name'];
$email = $row['email'];
$city = $row['city'];
$street = $row['street'];
$unit_no = $row['unit_no'];
$province = $row['province'];
$country = $row['country'];
$postal_code = $row['postal_code'];
$birth_date = $row['birth_date'];
$telephone = $row['telephone'];
$oasis = $row['oasis'];
}
}TWB