Using results in another query before echo

[matthewst]

I'm trying to:
$query="SELECT fname, lname FROM employees WHERE employee_id=$employee_id";

echo "fname lname";

Right now the page displays the employee ID, but I need it to display the employee's name.

$query="SELECT ad_order.company company, job_log.employee_id employee_id, job_log.time time, job_log.action action FROM ad_order LEFT JOIN (job_log) ON (job_log.ad_id=ad_order.id) WHERE ad_order.cust_id=$table_id ORDER BY company,time";
$result=mysql_query($query);
while ($row = mysql_fetch_assoc($result))

{
$company = $row['company'];
$time = $row['time'];
$employee_name = $row['employee_id'];
	if ($employee_name=="")
	$employee_name = "No Entry";
	else
	$employee_name = $row['employee_id'];
$action = $row['action'];
	if ($action=="")
	$action = "No Entry";
	else
	$action = $row['action'];
$showtime = date('m/d/y-h:m:s',$time);
	if ($showtime=="12/31/69-06:12:00")
	$showtime = "No Entry";
	else
	$showtime = date('m/d/y-h:m:s',$time);

echo "$company - $employee _name - $showtime - $action";
}

[BrandonK]

You can't just select it in the initial query?

SELECT ad_order.company company
     , employees.employee_id employee_id
     , employees.fname employee_fname
     , employees.lname emplyoee_lname
     , job_log.time time
     , job_log.action action 
  FROM ad_order 
  LEFT 
  JOIN job_log
    ON job_log.ad_id=ad_order.id
  LEFT
  JOIN employees
    ON employees.employee_id = job_log.employee_id
 WHERE ad_order.cust_id=$table_id
 ORDER 
    BY ad_order.company
     , job_log.time

[matthewst]

fname and lname are from a third table and I'm just a noob

I was able to get it to work with this just before the echo

[/code]$query2 = "SELECT * FROM employees WHERE employee_id = '$employee_name'";
* * * *$result2 = mysql_query($query2) or die(mysql_error());
* * * *while($row2 = mysql_fetch_assoc($result2))
* * * *{
* * * * * * * * $employee_name2 = $row2['fname']." ".$row2['lname'];
* * * *}[/code]

Thanks everyone!!

[BrandonK]

Did you try my query? If there is only 1 employee name per employee_id (seems logical), you could do it without using the nested queries and improve the code's performance and readability.