I am trying to create a unique module. In doing so I created a table called zen_employees. This table looks like this and has three columns.
employee_id | employee_first | employee_last.
1 | first1 | last1
2 | first2 | last2

I want to query TABLE_EMPLOYEES and then create a drop down list of the employees first names. I have tried using the wiki and I get error messages. I have tried searching for it. I get error messages. The only thing I have tried that hasn't given me an error message is
Code:
<?php
require('includes/application_top.php');
?>
<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">
<html <?php echo HTML_PARAMS; ?>>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">
<title><?php echo TITLE; ?></title>
<link rel="stylesheet" type="text/css" href="includes/stylesheet.css">
</head>
<select name="dropdown">
<?php
 $result1= mysql_query("SELECT * FROM TABLE_EMPLOYEES");
 while($row = mysql_fetch_array($result1)){
      echo '<option value="' . $row['employee_id'] . '">' . $row['employee_first'] . '</option>';
 }
?>
</select>
With this I don't get anything in my drop down box.

Any help would be appreciated.