Untitled

<?

$user="work";
$password="pandr";
$database="work";
mysql_connect(localhost,$user,$password);
@mysql_select_db($database) or die( "Unable to select database");


echo "<html><title></title><body>";
echo "<b><center>Versatility Chart</center></b><br><br>";


$dept=$_POST[dept];
//$dept=2;
echo "$dept";
//form
echo "<form action=\"chart.php\" method=\"post\">";
echo "Department: <select name=\"dept\">";
echo "<option value=\"1\">Spools</option>";
echo "<option value=\"2\">Reels</option>";
echo "<option value=\"3\">Plastics</option>";

echo "</select>";

echo "<input type=\"submit\">";
echo "</form>";

echo "<table border = 1><tr><td><b>Employee Name</b></td>";

$query2="SELECT * FROM Employees ORDER BY LastName";
$result2=mysql_query($query2);

while ($row = mysql_fetch_assoc($result)) {

$ID=$row['ID'];
$taskname=$row['TaskName'];

echo "<td>$taskname</td>";
}

echo "</tr>";

$idquery="SELECT * FROM Tasks WHERE Department=$dept ";
$idresult=mysql_query($idquery);
$num=mysql_numrows($idresult);

while ($row = mysql_fetch_assoc($result2)) {
        $LastName=$row['LastName'];
        $FirstName=$row['FirstName'];

        echo "<td> $LastName, $FirstName </td>";

        while ($idrow = mysql_fetch_assoc($idresult)) {
                $ID=$idrow['ID'];
                //$ability=0;
                $vers="task_$ID";
                $ability=$row['$vers'];

                echo "<td>$vers: $ability</td>";
        }

        unset( $idrow );
        echo "</tr>";
}
echo "</table>";

mysql_close();
?>