Lo, I have a script that gets all the info from a database and prints out the results in a table. The last column of the table is meant to print links to another file which will delete the record.. but I don't know how to create the links properly:
while(odbc_fetch_row($result))
{
$ID = odbc_result($result, 1);
$Alias = odbc_result($result, 2);
$Real_Name = odbc_result($result, 3);
$Location = odbc_result($result, 4);
$Email = odbc_result($result, 5);
print("<tr>\n");
print("<td><font face=\"Arial\">$ID</td>\n");
print("<td><font face=\"Arial\">$Alias</td>\n");
print("<td><font face=\"Arial\">$Real_Name</td>\n");
print("<td><font face=\"Arial\">$Location</td>\n");
print("<td><font face=\"Arial\">$Email</td>\n");
print("<td><font face=\"Arial\"><a href=\"delete.php?".$ID."\">Delete</a></td>\n");
print("</tr>\n");
and delete.php:
<?
$connection = odbc_connect("test.dsn", "NC", "TEST");
$Query = "DELETE FROM users WHERE ID = '$ID'
$del = odbc_exec($connection, $Query);
odbc_close($connection);
?>
Could anyone help? Ty 🙂
