Delete funktion
Hjælp det driller.hvordan for jeg sat en delete funktion på dette, sådan at der står delete ud for hver række at data , så jeg kan slette en intastning.
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Oversigt over tilmeldte</title>
</head>
<body>
<?php
$aid = $_GET['aid'];
mysql_connect("localhost", "user", "pass") or die(mysql_error());
mysql_select_db("db") or die(mysql_error());
if(isset($_POST['button'])){
$result = mysql_query("SELECT * FROM tilmdb WHERE arrid='$aid'")
or die(mysql_error());
while($row = mysql_fetch_array( $result )) {
$tilmid = $row['tid'];
$betal = $_POST['betalt_'.$tilmid];
if($betal=='on'){
$result2 = mysql_query("UPDATE tilmdb SET betalt='1' WHERE tid='$tilmid'")
or die(mysql_error());
}
else{
$result2 = mysql_query("UPDATE tilmdb SET betalt='0' WHERE tid='$tilmid'")
or die(mysql_error());
}
}
}
include 'connect.php';
$result = mysql_query("SELECT * FROM tilmdb WHERE arrid='$aid'")
or die(mysql_error());
echo '<form id="form1" name="form1" method="post" action="tilm_list.php?aid='.$aid.'">
<table width="876" border="1" cellpadding="0" cellspacing="0">
<tr>
<td width="172"><em>ID</em></td>
<td width="172">Navn</td>
<td width="175">Adresse</td>
<td width="109">Telefon</td>
<td width="173">E-mail</td>
<td width="89">Antal voksne</td>
<td width="88">Antal Børn</td>
<td width="70">Betalt</td>
</tr>';
while($row = mysql_fetch_array( $result )) {
$tid = $row['tid'];
$navn = $row['tnavn'];
$adr = $row['tadr'];
$by = $row['tby'];
$pnr = $row['tpnr'];
$mail = $row['tmail'];
$tel = $row['ttel'];
$numv = $row['numv'];
$numb = $row['numb'];
$medl = $row['medl'];
$betalt = $row['betalt'];
if($betalt=='1'){
$text = '<input type="checkbox" name="betalt_'.$tid.'" id="betalt" checked="checked" />';
}
else{
$text = '<input type="checkbox" name="betalt_'.$tid.'" id="betalt" />';
}
echo '<table width="876" border="1" cellpadding="0" cellspacing="0">
<tr>
<td width="17">'.$tid.'</td>
<td width="172">'.$navn.'</td>
<td width="175">'.$adr.' '.$pnr.', '.$by.'</td>
<td width="109">'.$tel.'</td>
<td width="173">'.$mail.'</td>
<td width="89">'.$numv.'</td>
<td width="88">'.$numb.'</td>
<td width="70">'.$text.'</td>
</tr>';
}
echo'</table>
<input type="submit" name="button" id="button" value="Opdater betalinger" /></form>';
?>
</body>
</html>
