Problemer med checkboxes
Jeg har en form hvor jeg submitter noget info til en database.Den info kan man gå ind i en admin del og acceptere eller delete.
Men jeg har det problem at jeg kun kan acceptere/delete en ting adgangen.
Dvs, sætter jeg fx hak i mere end 1 checkbox og submitter, så accepterer/deleter den bare den øverste checkbox der er sat hak i.
Har ingen ide om hvad jeg kan gøre?
Koden ser således ud;
<?php
include("setup.inc");
@mysql_connect($server, $db_user, $db_pass);
@mysql_select_db($database);
$query = mysql_query("SELECT * FROM tgp WHERE await='1' order by id");
if(isset($submit)) {
$update = mysql_query("UPDATE tgp SET await=0 WHERE id='$check'");
$delete = mysql_query("DELETE FROM tgp WHERE id='$check_del'");
header("Location: http://www.xxx-portal.net/tgp/tgp_admin.php");
}
?>
<table border="0" cellpadding="0" cellspacing="0" width="700" align="center">
<tr>
<td width="54"><font face="Verdana" size="2"><strong>Date</strong></font></td>
<td width="108" align="center"><font face="Verdana" size="2"><strong>Category</strong></font></td>
<td width="268" align="center"><p align="center"><font face="Verdana" size="2"><strong>Url</strong></font></td>
<td width="138" align="center"><font face="Verdana" size="2"><strong>Name</strong></font></td>
<td width="68" align="center"><font face="Verdana" size="2"><strong>Accept</strong></font></td>
<td width="64" align="center"><font face="Verdana" size="2"><strong>Delete</strong></font></td>
</tr>
<?
$query = mysql_query("SELECT * FROM tgp WHERE await='1' order by id");
while($row = mysql_fetch_array($query)) {
echo "
<tr>
<td width=\"54\"><font face=\"Verdana\" size=\"1\">$row[date]</font></td>
<td width=\"108\" align=\"center\"><font face=\"Verdana\" size=\"1\">$row[category]</font></td>
<td width=\"268\" align=\"center\"><p align=\"left\"><font face=\"Verdana\" size=\"1\"><a href=\"$row[url]\" target=\"_blank\">$row[url]</a></font></td>
<td width=\"138\" align=\"center\"><font face=\"Verdana\" size=\"1\">$row[name]</font></td>
<td width=\"68\" align=\"center\"><font face=\"Verdana\" size=\"1\"><form method=post action=$PHP_SELF><input type=checkbox name=check value=$row[id]></font></td>
<td width=\"64\" align=\"center\"><font face=\"Verdana\" size=\"1\"><input type=checkbox name=check_del value=$row[id]></font></td>
</tr>
";
}
echo "<input type=submit name=submit><input type=reset>
</form>";
?>
