[infinitylimit]

First of all the code you supplied doesn't have an $id defined so that is why you are having a problem. I'm assuming you want to use the primary key of the table and that primary key is EmployeeID. Below is the code that will work.

PHP Code:

<a href="update.php?id=<?php echo $EmployeeID; ?>">Update</a>

update.php will need to do a $_GET['id'] to be able to find the information needed.

I also noticed that you are using a wildcard SQL statement. If you plan on using this a lot you might want to do something like SELECT employeeID,CrewID, ... ect instead of *

You might also peek at http://us2.php.net/mysql_result for information regarding it's use on large sets of data.

Hope this helps,
-IL