still missing something (i'm an idiot
)
when usuing what u suggested, the link is right with the update.php?id=employee id here. but when clicked it looks to me like its still trying to use the ID instead.... primary key is ID with autoinc and now EmployeeID.
employee.php:
*********
<?
include("dbinfo.inc.php");
mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT Employee,EmployeeID,CrewID FROM EmpInfo";
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();
echo "<b><center>Employee Database</center></b><br><br>";
?><body background="arb.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</font></th>
<th><font face="Arial, Helvetica, sans-serif">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=<?php echo $EmployeeID; ?>">Update</a></font></td>
<td><font face="Arial, Helvetica, sans-serif"><a href="delete.php?ID=<?php echo $EmployeeID; ?>">Delete</a></font></td>
</tr>
<?
++$i;
}
echo "</table>";
?>
**************
update.php
**************
<?
include("dbinfo.inc.php");
$ID=$_GET['ID'];
mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT Employee,EmployeeID,CrewID FROM EmpInfo WHERE ID='$ID'";
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();
$i=0;
while ($i < $num) {
$Employee=mysql_result($result,$i,"Employee");
$EmployeeID=mysql_result($result,$i,"EmployeeID");
$CrewID=mysql_result($result,$i,"CrewID");
?>
<form action="updated.php" method="post">
<input type="hidden" name="ud_ID" value="<? echo "$ID"; ?>">
Employee: <input type="text" name="ud_Employee" value="<? echo "$Employee"?>"><br>
Employee ID: <input type="text" name="ud_EmployeeID" value="<? echo "$EmployeeID"?>"><br>
Crew ID: <input type="text" name="ud_CrewID" value="<? echo "$CrewID"?>"><br>
<input type="Submit" value="Update">
</form>
<?
++$i;
}
?>