Need help with an Array from checkboxes

[Anon]

Hi all,

I am new to PHP and I am trying to create an array to update a database

Here is where I am having trouble

<CODE>
<FORM NAME="Form_1" ACTION="updatenav.php" METHOD=POST onSubmit="return _SC_checkForm_1(this)">

<?
$i = 0;
while($row = mysql_fetch_array($sth)){
if ($row[id] == $output[$i]){
$checked = "CHECKED";
}
printf("<tr><td width=\"20\" align=\"right\" bgcolor=\"#CCDDFF\"><INPUT TYPE=\"checkbox\" NAME=\"Permissions[]\" VALUE=\"$row[id]\" $checked></td><td bgcolor=\"#CCDDFF\"><b>$row[title]</b> - $row[description]</td></tr>\n");
$i++;
}
?>

</CODE>

This displays the form properly.

Here is the updatenav.php code

<CODE>

<?
$permissions = array($Permissions);
$newperm = implode(",",$permissions);
$link = mysql_connect ("$dbhost", "$dbuname", "$dbpass")
or die ("Could not connect to database");
mysql_select_db($dbname2);
$stmt = "UPDATE USERS set permissions='$newperm' where id = '$ID'";
mysql_query($stmt, $link);
?>

</CODE>

This is where I am having trouble. I do not know how to create an Array from the form.

What shows in the database where the update should be is "Array".

Thanks

[Anon]

$Permissions is already treated as an array, so you can omit the first line here:
$permissions = array($Permissions);

Changer lowercase $permissions to uppercase $Permissions in your next line and it should work i think

<?
$permissions = array($Permissions);
$newperm = implode(",",$permissions);
$link = mysql_connect ("$dbhost", "$dbuname", "$dbpass")
or die ("Could not connect to database");
mysql_select_db($dbname2);
$stmt = "UPDATE USERS set permissions='$newperm' where id = '$ID'";
mysql_query($stmt, $link);
?>

</CODE>

[Anon]

Thank you soooo much!!
I thought I had tried that once but it did not work. It works great!!

Larry

[Anon]

hi there, i need similar help...

i am trying to generate a table of users with checkboxes to be able to approve or not...once the c/boxes are checked and sent the db is updated...trouble is i am having is with separating the values in the array so that the form updates the corret user...

code for update form...

<form action="new_approve.php" method="post">
<?php
$sqlquery = "SELECT * FROM users WHERE active='0'";
$result = mysql_query($sqlquery,$connection);
$number = mysql_numrows($result);

$i = 0;

if ($number < 1) {
print "<tr><td colspan=\"8\">There are no new users to approve!</td></tr>";
}
else {
while ($number > $i) {
$thisName = mysql_result($result,$i,"first_name");
$thisLast = mysql_result($result,$i,"second_name");
$thisUser = mysql_result($result,$i,"user_name");
$thisEmail = mysql_result($result,$i,"email");
$thisActive = mysql_result($result,$i,"active");
$thisAdmin = mysql_result($result,$i,"admin");
$thisID = mysql_result($result,$i,"ID");

print "
<TR>
<TD>$thisName</TD>
<TD>$thisLast</TD>
<TD>$thisUser</TD>
<td>$thisEmail</td>
<td><input type=\"checkbox\" name=\"del[]\" value=\"$thisID\"></td>
<td>$thisAdmin</td>
<td>$thisID</td>
</TR>";
$i++;
}
}

code for new_approve
$sql="UPDATE users SET active='1' WHERE ID='$thisID'";
do {
mysql_query($sql,$connection);
}
while($x = each($del));

#{
#echo "$x[0] => $x[1]<BR>";
if (!mysql_query($sql,$connection)) {
echo "sorry Could not approve users";
}
else {
echo "Users Approved!<br>Back to <a href=\"admin.php\">Main Admin Page</a>";
}

i am v.new to php so would appreciate any help...!
mamu