Hello and help.
trying a new one this time - Checkbox array.
Can't see the problem with the below code. Its as if the array doesn't contain any values
Cheers..
<?php
include('../../php-functions/dbconContacts.php');
?>
<html>
<head>
<title>Membership Admin</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
<!--
.formtext { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: x-small; color: #000099}
.button { font:9pt Verdana, Arial, Helvetica, sans-serif; border:1 solid #004FA3; cursor:hand; background:#FFFFFF; color: #004FA3; }
.button2 { font:9pt Verdana, Arial, Helvetica, sans-serif; border:1 solid #004FA3; cursor:hand; background:#004FA3; color: #FFFFFF; }
-->
</style>
<style>
BODY {SCROLLBAR-FACE-COLOR: #004FA3; SCROLLBAR-HIGHLIGHT-COLOR: #004FA3; SCROLLBAR-SHADOW-COLOR: #004FA3; SCROLLBAR-3DLIGHT-COLOR: #004FA3; SCROLLBAR-ARROW-COLOR: #BF97C4; SCROLLBAR-TRACK-COLOR: #BF97C4; SCROLLBAR-DARKSHADOW-COLOR: #004FA3; }
</style>
</head>
<body bgcolor="#FFFFFF" text="#ed1c24" link="#003399" vlink="#ed1c24" alink="#ed1c24">
<b></b><br>
<?php
$TodayRef = date("Ymd");
$Counter = 0;
ConnectNoticeBoard();
$sql = "select * from membership_shout order by id desc";
$result = mysql_query($sql);
//
if(mysql_num_rows($result)>=1):
printf("<form name=\"form1\" method=\"post\" action=\"%s\">",$PHP_SELF);
print("<table width=\"90%\" border=\"0\" cellspacing=\"1\" cellpadding=\"1\" align=\"center\">");
while ($row = mysql_fetch_array($result)) {
$Id = $row["id"];
$Shout = $row["shout"];
print("<tr>");
print("<td align=\"left\" valign=\"top\" width=\"5%\">");
printf("<input type=\"hidden\" name=\"MS_Id%s\" value=\"%s\">",$Counter,$Id);
printf("<font size=3 class=formtext color=\"#ed1c24\"><b>%s</b></font>",$Id);
print("</td>");
print("<td valign=\"top\" align=\"center\" width=\"90%\">");
printf("<font size=2 class=formtext color=\"#003399\"><b>%s</b></b></font>",$Shout);
print("</td>");
print("<td valign=\"top\" align=\"right\" width=\"5%\">");
//printf("<input type=\"checkbox\" name=\"CheckBox%s\" value=\"checkbox\">",$Counter);
printf("<input type=\"checkbox\" name=\"CheckBox[]\" value=\"%s\">",$Id);
print("</td>");
print("</tr>");
$Counter++;
}
print("</table>");
print("<br>");
print("<br>");
print("<table width=\"90%\" align=\"center\" border=\"0\" cellspacing=\"1\" cellpadding=\"1\" >");
print("<tr>");
print("<td align=\"right\" valign=\"top\" width=\"100%\">");
print("<input type=\"submit\" name=\"Delete\" value=\"Delete\" align=\"right\"> ");
printf("<input type=\"hidden\" value=\"%s\" name=\"intCounterMax\">",$Counter);
print("</td>");
print("</tr>");
print("</table>");
print("</form>");
else:
echo "<font face=Arial size=3 color=\"#ed1c24\"><b>No news items</b></font><br>";
endif;
mysql_free_result($result);
if (isset($Delete)){
$NewCount = 0;
ConnectNoticeBoard();
$Bobba = $_POST['Checkbox'];
while ($NewCount <= $intCounterMax) {
$Fett = $Bobba[$NewCount];
?><script>alert('<?= $Fett ?>');</script><?
$Sql = "DELETE FROM membership_shout where id = $Fett";
// mysql_query($Sql);
$NewCount++;
}
?><script>location.replace('delete.php');</script><?
}
?>
</body>
</html>
My Checkbox array hell
Moderator: General Moderators
-
pootergeist
- Forum Contributor
- Posts: 273
- Joined: Thu Feb 27, 2003 7:22 am
- Location: UK