hov, det var sq da en forkert c/p
-----------------------------
<?php
/**
*
* Delete from questbook
* by Frank 'knarf' Thomsen
*
www.frankthomsen.net **/
/*CREATE TABLE `tagwall` (
`id` INT NOT NULL ,
`navn` VARCHAR( 250 ) NOT NULL ,
`besked` TEXT NOT NULL ,
`mail` VARCHAR( 250 ) NOT NULL ,
`hp` VARCHAR( 250 ) NOT NULL ,
INDEX ( `id` )
);
*/
$host = ""; // the hostname
$user = ""; // the username
$pass = ""; // the password
$database = "" // the databasename
mysql_connect("$host", "$user", "$pass");
mysql_select_db("$database");
$prefix = "";
$table = $prefix."tagwall";
// Display delete sektion
print "<TABLE align=\"center\"><TR><TD>";
print "
<TABLE align=\"left\" width=\"450\" cellpadding=\"0\" cellspacing=\"0\">
<TR>
<TD class=\"newstop\"> </TD>
</TR>
<TR>
<TD class=\"newsborder\"><DIV style=\"margin: 10px 5px 5px 10px;\">";
// Connect to the database and display the entries
$guestbook_result = mysql_query("SELECT id,navn FROM $table ORDER by 'id' DESC") or die(mysql_error());
print"
<form action=\"?delete=true\" method=\"POST\">\n
<TABLE width=\"100%\">\n
<TR>\n
<TD width=\"10px\"><b>#</b></TD>\n
<TD><b>Navn</b></TD>\n
<TD><b>Dato</b></TD>\n
<TD><b>Delete</b></TD>\n
</TR>\n
";
$id = "";
while($row = mysql_fetch_array($guestbook_result)){
$i = $i + 1;
print"
<TR>\n
<TD>".$i."</TD>\n
<TD>".$row[1]."</TD>\n
<TD>".date("d/m/Y - H:i",$row[0])."</TD>\n
<TD><input type=\"checkbox\" name=\"delete-".$row["id"]."\" value=\"".$row["id"]."\"/></TD>\n
</TR>\n
";
$id = $id.",".$row["id"];
}
print "
</TABLE>\n
<input name=\"submit\" type=\"submit\" value=\"Submit\"/>\n
</form>\n
";
print "
</DIV></TD>
</TR>
<TR>
<TD class=\"newsbottom\"> </TD>
</TR>
</TABLE>
";
print "</TD></TR></TABLE>";
if ($_GET["delete"] == "true") {
$id = substr($id,1);
$id = explode(",", $id);
$x = count($id);
for ($i=0;$i<=$x;$i++){
if ($_POST["delete-".$id[$i]] != "") {
$mysqldelete = "DELETE FROM $table WHERE id = '$id[$i]'";
mysql_query($mysqldelete) or die(mysql_error());
}
}
// header("Location: ?admin=news");
exit;
}
mysql_close();
?>
