Storing checkbox values in MySQL

[Anon]

Hello,

I sincerely hope that someone had experienced the same problems (and solved it of course :-)).

The problem:
I nedd to store checkbox data in MySQL, where every checked value has own record in table.

I have a table called privileges, containing following columns:
priv_id | priv_name | user_id

In priv_name can be stored 10 possible values (10 possible privileges). So, when I create new user account, checked privleges from checkbox form must be inserted in MySQL as one record each.

I realize that solution can be something like this:
gathering all ckecked elements in array and looping the query while content of array is exausted.

However, I would appreciate any help on this, the relevant code is also very welcome.

Thanks in advance,
lancelot_

[chowdary]

Hi,
While naming the check boxes name all of them with the same name (of course an array) i.e like "prev[]";

Now to submit the checked data

for($i=0;$i<count($prev);$i++)
{
if(!empty($prev[$i]))
{
$privilege=$prev[$i];
$qry="..............";
............
}
}

Hope this works for you

Cheers
Ajay

[Anon]

Firstable, tnx Ajay for prompt reply.
Ajay's code worked out, with slight modification.

So, storing checkbox values as separate ecords in table is reached through simple loop:

....
for($i=0;$i<count($check);$i++)
{
if(!empty($check[$i]))
{

    $query="INSERT INTO privilege (priv) values ('$check[$i]')";

    $rez = mysql_query ($query, $link_id);
  }

}
...
where $check is an array holding values submited from checkboxes.