Problem displaying array in checkboxes

[marioproenca]

Hi
I'm trying to display an array that was previously submited to the database from checkbox inputs.
What is going wrong now, is that the values are there in the db but I can't get the ckecboxes to be checked.
Thanks in advance for any help here.
MP

The insert code (functioning okay):

if ($ned_array!=0) {
$notif_empr_distrito = implode($ned_array, ",");
} else {
$notif_empr_distrito="";
}

The display code NOT FUNCTIONING

<?
$result=mysql_query("SELECT notif_empr_distrito FROM utilizadores WHERE userID=$cookieuserID") or die(mysql_error());
$ned_array=explode(";",$notif_empr_distrito);

?>
<tr>
<td bgcolor="#F8FAF8" class="bodyslhpv" width="17%"><input type="checkbox" name="ned_array[]" value="1" <?= ($ned_array["notif_empr_distrito"]==1)?"checked":""; ?>> Açores</td>
<td bgcolor="#F8FAF8" class="bodyslhpv" width="17%"><input type="checkbox" name="ned_array[]" value="11" <?= ($ned_array["notif_empr_distrito"]==11)?"checked":""; ?>> Leiria</td>
<td bgcolor="#F8FAF8" class="bodyslhpv" width="17%"><input type="checkbox" name="ned_array[]" value="15" <?= ($ned_array["notif_empr_distrito"]==15)?"checked":""; ?>> Porto</td>
</tr

[fitzbean]

td bgcolor="#F8FAF8" class="bodyslhpv" width="17%"><input type="checkbox" name="ned_array[]" value="1" <?= ($ned_array["notif_empr_distrito"]==1)?"checked":""; ?>> Açores</td>

?

name="ned_array[]" <-- your not specifying an array element....

[marioproenca]

Thanks for your reply.

Even though it seemed that the problem was that, humm.. no, it doesn't work.
But if I put there this code:

<?
if($s!=1){
$result=mysql_query("SELECT * FROM utilizadores WHERE userID=$cookieuserID") or die(mysql_error());
$userInfo=mysql_fetch_array($result);

?>

...and replace the $ned_array with $userInfo as below, I only get the first result, this is, the first checkbox checked, even all of them should be.
Now it seems that here is missin some loop to display all the variable?!...

<input type="checkbox" name="ned_array[]" value="1" <?= ($userInfo["notif_empr_distrito"]==1)?"checked":""; ?>> Açores</td>

<?
if($s!=1){
$result=mysql_query("SELECT * FROM utilizadores WHERE userID=$cookieuserID") or die(mysql_error());
$userInfo=mysql_fetch_array($result);

?>

[fandelem]

---

$result=mysql_query("SELECT notif_empr_distrito FROM utilizadores WHERE userID=$cookieuserID") or die(mysql_error());

$ned_array=explode(";",$notif_empr_distrito);

your problem: where is $notif_empr_distrito coming from? no where, right now.

try this:
$result=mysql_query("SELECT notif_empr_distrito FROM utilizadores WHERE userID=$cookieuserID") or die(mysql_error());
$row = mysql_fetch_array($result);
$ned_array=explode(";",$row["notif_empr_distrito"]);

what you're doing is getting a resource is ($result), then fetching the array that matches the resource id ($row) and then you're building an array delimited by semi colons from the field notif_empr_distrito.

hth,

kyle

[marioproenca]

Thanks for your contibution. Unfortunately it does not wor either. Humm... I'm just thinking of other method to store these data, since I have to go on with the project.
Any suggestions? Thanks anyway.
MP