Hey guys, I have a page that is loaded using php/mysql displays the results into a table, i have added an extra column for a "up date / change" option.
how do I use the ?id=$id for a link, for each individual row (person), something like my website/update.php?id=$id where $id would be the persons id from my DB.. code as follows:
<?
include("dbinfo.inc.php");
mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM EmpInfo";
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();
echo "<b><center>Employee Database</center></b><br><br>";
?><body background="back.gif">
<table border="1" cellspacing="2" cellpadding="2">
<tr>
<th><font face="Arial, Helvetica, sans-serif">Employee</font></th>
<th><font face="Arial, Helvetica, sans-serif">EmployeeID</font></th>
<th><font face="Arial, Helvetica, sans-serif">CrewID</font></th>
<th><font face="Arial, Helvetica, sans-serif">Update / Delete</font></th>
</tr>
<?
$i=0;
while ($i < $num) {
$Employee=mysql_result($result,$i,"Employee");
$EmployeeID=mysql_result($result,$i,"EmployeeID");
$CrewID=mysql_result($result,$i,"CrewID");
?>
<tr>
<td><font face="Arial, Helvetica, sans-serif"><? echo "$Employee"; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><? echo "$EmployeeID"; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><? echo "$CrewID"; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><a href="update.php?id=$id">Update</a></font></td>
</tr>
<?
++$i;
}
echo "</table>";
?>