[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

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

[kh99]

Originally Posted by m002.p

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.

And what happens when that's the case?

[m002.p]

Hi, thanks for your response.

I dont follow what you mean.

Heres an example.

Row 'offenses' for ID 4; Team Killing, Spamming, ROE Violations

Out of all the checkbox possibilities as displayed with array $a_offenses, only the first value "Team Killing" is checked and not the other 2 in the example using the code posted.

Hope that answers your query?

Matt

[kh99]

Oh, I get it now. I thought you meant some problem was happening if you checked only one box.

Anyway, I think your problem is that explode(',', array) splits by comma but doesn't take away the extra spaces. Try this:

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

[m002.p]

Genius, works like a charm. Thank you, something so simple but so simply overlooked.

Matt

[kh99]

Yeah, sometimes it just takes a fresh pair of eyes.

[m002.p]

Hi Kh99,

I know its been a while since I had this issue, but I have since been trying using another method.

Instead of using the old method:

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

I am now retrieving this array from a MYSQL table.

Example:

$a_offenses = $db_offenses['list'];

Value stored in MYSQL column 'list' is the array eg. "Team Killing, Team Tazing, Team Nading" etc.

Now the problem is back again. I removed your first solution to simply:

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

and it partially works. When I say partially, multiple boxes are ticked but for some elements of the array the box remains unticked.

Eg.

Offenses listed in DB; Team Killing, Team Tazing, Rambo Gameplay

Checkboxes ticked: Team Killing, Rambo Gameplay

So some are missed from the stored values. I looked at how both arrays are stored in the DB and cant see any extra spaces.

Can you help?

--------------- Added 29 Jul 2012 at 17:59 ---------------

Dont worry, forgot to pass both variables through array_map.

Thanks once again!