To ADD a new employee
select any employee
and overwrite its data.

To modify or delete an
employee, click on its
ID then choose the
appropriate action

// --------------------------------------------------------
//    the code
// --------------------------------------------------------
	<div id="leftsidebar">
        <br>
        <br>
        To ADD a new employee
        <br>
        select any employee
        <br>
        and overwrite its data.
        <br>
        <br>
        To modify or delete an
        <br>
        employee, click on its
        <br>
        ID then choose the
        <br>
        appropriate action
        <br>
        <br>
        <br>
    </div>
    
<?php
include 'common.php';
$link = db_connect();
echo "<div>";
// --- select employee fields for display ---
$query = 'SELECT employee_id, last_name, first_name FROM emp_php ORDER BY employee_id';
$result = mysql_query($query) or die('Query failed: ' . mysql_error());

// -----------------------------------------------------------------------
//  display employees in a table with the first column selectable
//  selecting an employee goes to an add, modify, or delete choice
// -----------------------------------------------------------------------
echo "<div id='results'>";
echo "<table id='emp' border='1' >\n";
echo "<thead>";
echo "<TR><TH COLSPAN=\"3\"><H3><BR>employees</H3></TH>";
echo "<tr><th>ID</th><th>Last Name</th><th>First Name</th></tr>";
echo "</thead>";

while ($row = mysql_fetch_array($result, MYSQL_BOTH))
{
    echo "<tr>";
    $id = $row[0];
    $ln = $row[1];
    $fn = $row[2];
    echo "   <td><input type=\"button\" value=\"$id\" class=\"sel\" 
                            onmouseover=\"mouseover(this)\"
                            onmouseout=\"mouseout(this)\"
                                    onclick=\"rowsel(this.value)\"> 
                        </td>";
    echo "   <td>$ln</td>";
    echo "   <td>$fn</td>";
    echo "</tr>";
}
echo "</table>\n";
echo "</div>";

// --- Free resultset, Close Connection ---
mysql_free_result($result);
mysql_close($link);
echo "</div>";