Retrieving checkbox values from MYSQL

[m002.p]

Hello everyone.

I am tearing my hair out with this one and I sort of know the reason why it wont work, being a loop issue but I cant see where I am going wrong.

I have checkboxes as seen in the $a_offenses array. I want the script to check the MYSQL table row 'offenses' which contains an array of those selected checkboxes in the format 'VALUE 1, VALUE 2, VALUE 4, VALUE 6' for example.

The problem comes where the first value eg. VALUE 1 is ticked in the list of checkboxes but the others are not and left unchecked.

Any ideas?

PS - The $c counter is used to ensure only 3 checkboxes are displayed per row ie. formatting only nothing else

Thanks in advance.

Matt

PHP Code:

// Query DB
$query = mysql_query("SELECT offenses FROM reports WHERE id='$id'");
// Get ROW
$row = mysql_fetch_array($query);

// Store all checkboxes as array
$a_offenses = array("Team Killing", "Team Tazing", "Team Nading", "Team Peppering", "Team Injuring", "Insulting Players", "Insulting Admins", "Insulting Clan Members", 
"Tag Stealing", "Cheating / Hacking", "Disallowed Name", "Inappropiate Language", "Spamming", "Advertising / Recruiting", "Rambo Gameplay", "Random Shooting" , "ROE Violations", 
"Use of Non-English", "Dropping as VIP", "Spawn Killing", "Camping", "Injuring / Killing VIP", "Injuring / Killing Civilians");

// Explode stored checkboxe values from DB selected
    $offenses = explode(',',$row['offenses']);

 $c = 0;
  foreach ($a_offenses as $offense) {
 
$c++;
 
        if(in_array($offense,$offenses)) 
    {
        if($c % 3 == 0)
        {
                  echo "<tr><td><input name=\"offenses[$c]\" type=\"checkbox\" value=\"$offense\" checked> $offense</td>";
        }
        else
        {
            echo "<td><input name=\"offenses[$c]\" type=\"checkbox\" value=\"$offense\" checked> $offense</td>";
        }
        } 
    else
        {
              if($c % 3 == 0)
        {
                  echo "<tr><td><input name=\"offenses[$c]\" type=\"checkbox\" value=\"$offense\"> $offense</td>";
        }
        else
        {
            echo "<td><input name=\"offenses[$c]\" type=\"checkbox\" value=\"$offense\"> $offense</td>";
        }
        }
              }