Hi guys, i'm trying to make a "update user's power" page. It is something similar to those you can find in say, invisionfree forums.

I need it to generate a list of members with checkbox [done] Add an option for it [done]

What i don't know how to do is to update, to say, give all the selected users the selected power.

Then i went searching for something and found most of them uses array to do this, but i never found one that actually explains how it works.

The example i took (with my own modification) was this:

while($row = mysql_fetch_array($result))
{
echo    '<tr>'.$id[]=$rows['id'].'';
echo    '<td width="50px" align="center" class="TableFormCell"><input type="checkbox" name="option[]" /></td>';
echo    '<td width="170px" align="center" class="TableFormCell">'.$row['uname'].'</td>';
echo    '</tr>';
}

I'm not sure what exactly $id[]=$rows['id'] does

I know after the row, my option[] would become an array of option[1], option[2], option[3]

for what power should be given, i've got no problem with that but on how to update the database i'm got no clue...

for($i=0;$i<$count;$i++){
$sql1="UPDATE ninos SET power='$power' WHERE id='$option[$i]'";
$result1=mysql_query($sql1);
}

So Say i have 5 users, Aye, Bee, Cee, Dee, Eee with IDs of 1,2,3,4,5 how can i make it so that my script would run like

$sql1="UPDATE ninos SET power = '$power' Where id='1','2','3','4','5'";

Please help, thanks.