Slet flere på en gang
Jeg har denne gæstebog på mit community.Og jeg ville gerne have brugere skulle kunne slette sine beskeder, altså flere på en gang ved at afkrydse en ckeckbox, her er min kode:
Den sletter ikke den sender bare en ud på index.php
<?php
include("includes/mysql.php");
if(!$_GET["id"])
{
header("Location: index.php");
}
$connn = mysql_query("SELECT * FROM users WHERE id = '$_GET[id]'");
$rsss = mysql_fetch_array($connn);
if(mysql_num_rows($connn) == 0) {
header("Location: index.php");
}
if($_SERVER["REQUEST_METHOD"] == "POST")
{
$cii = mysql_query("SELECT * FROM users WHERE id = '$_GET[id]'");
$rii = mysql_fetch_array($cii);
for ($i=0; $i < 10; $i++)
{
if ($_POST["mail" . "$i"])
{
$conn = mysql_query("SELECT * FROM gb WHERE id = '".$_POST["mail" . "$i"]."'") or die (mysql_error());
if (mysql_num_rows($conn))
{
mysql_query("DELETE FROM gb WHERE id = '".$_POST["mail" . "$i"]."'") or die (mysql_error());
}
}
}
$con = mysql_query("SELECT * FROM users WHERE brugernavn = '$_SESSION[brugernavn]'");
$rss = mysql_fetch_array($con);
$sql = "INSERT INTO gb (to_user, forum_user, date, besked)
values('".$_GET["id"]."',
'".$rss["id"]."',
'".date("Y-m-j H:i:s")."',
'".$_POST["besked"]."')";
mysql_query($sql) or die(mysql_error());
}
$conn = mysql_query("SELECT * FROM users WHERE brugernavn = '$_SESSION[brugernavn]'");
$rs = mysql_fetch_array($conn);
$conn2 = mysql_query("SELECT * FROM gb WHERE to_user = '$_GET[id]'");
$rs2 = mysql_fetch_array($conn2);
$conn3 = mysql_query("SELECT * FROM users WHERE id = '$_GET[id]'");
$rs3 = mysql_fetch_array($conn3);
include("includes/top.php");
include("includes/brugermenu.php");
?>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="indhold-topbar-bg">Gæstebog for <?=$rs3["brugernavn"];?> | <?=mysql_num_rows($conn2);?> indlæg</td>
</tr>
</table>
<form name="submit" method="post" action="<?=$PHP_SELF?>">
<br />
<textarea cols="50" rows="8" name="besked"></textarea><br><br>
<input type="submit" name="submit" value="Skriv besked">
<input type="button" value="Smileys" onClick="Newwin=window.open('smileys.php','Newwin','height=500,width=500,toolbar=no,status=no,scrollbars=yes,resizable=yes'); ">
</form><br /><br />
<form action="<?=$_SERVER["PHP_SELF"];?>" method="post" name="form">
<? if(mysql_num_rows($conn2) == 0) { print "Der er desværre ingen beskeder i gæstebogen."; }
$conn5 = mysql_query("SELECT * FROM gb WHERE to_user = '$_GET[id]' ORDER BY id DESC");
while($rs5 = mysql_fetch_array($conn5))
{
$conn4 = mysql_query("SELECT * FROM users WHERE id = '$rs5[forum_user]'");
$rs4 = mysql_fetch_array($conn4);
$cunn = mysql_query("SELECT * FROM online_profiles WHERE brugernavn = '$rs4[brugernavn]'");
$ruu = mysql_fetch_array($cunn);
if($rs4["kon"] == "Dreng") { $kon = "D"; } elseif($rs4["kon"] == "Pige") { $kon = "P"; }
?>
<table width="100%" cellspacing="0" cellpadding="2">
<tr>
<td width="100%" class="text" style="background: <?=$rs4["bcolor"];?>; color: <?=$rs4["fcolor"];?>; border-top: 1px solid <?=$rs4["fcolor"];?>; border-bottom: 1px solid <?=$rs4["fcolor"];?>;">
<b><?php if(mysql_num_rows($cunn) == 1) { ?><span class="online"><a href="profil.php?id=<?=$rs4["id"];?>"><?=$rs4["brugernavn"];?></a></span><?php } else { ?><a href="profil.php?id=<?=$rs4["id"];?>"><?=$rs4["brugernavn"];?></a><?php } ?></b> <?=$kon?><?=$rs4["alder"];?> | <?=format_date("\\D\e\\n. j F Y - \\K\\l\\. H:i", $rs5["date"]);?> | <b><a href="java script:window.open('svar.php?id=<?=$rs4["id"];?>','Detaljer','toolbar=0,status=0,scrollbars=yes,resizable=no,width=400,height=240,top=50,left=50').focus();void(0)">Gb</a><b>,</b> <a href="profil.beskeder.php?action=sendbesked&id=<?=$rs4["id"];?>">Pb</a> | <a href="profil.gb.php?id=<?=$rs4["id"];?>">Se Gb</a></b>
<?php if($rs["id"] == $_GET["id"]) { ?> | <input class="checkbox" type="checkbox" name="mail<?=$nr;?>" value="<?=$rs5["id"];?>"><?php } ?>
</td>
</tr>
<tr>
<td width="100%" class="text" style="background: <?=$rs4["bcolor"];?>; color: <?=$rs4["fcolor"];?>;">
<?php if(file_exists("images/profiles/$rs4[id].jpg")) { ?><img src="images/profiles/<?=$rs4["bnavn"];?>" width="100" height="75" align="right"><?php } ?>
<? echo nl2br(smilies(nohtml($rs5[besked]))) ?>
</td>
</tr>
</table>
<?php
}
?>
<?php
if($rs["id"] == $_GET["id"]) { ?><br />
<b><a OnClick="return confirm('Er du sikker på at du vil slette de markerede beskeder?');" href="java script:form.submit();">Slet de markeret beskeder</a></b><?php } ?>
</form>
<?php
include("includes/bund.php");
?>
Jeg er villig til at give alle de points jeg kan give hvis jeg kan få dette problem løst
