help with arrays pls

[Jaret]

I spent whole day trying to figure this out but I'm too bad with arrays and statements, so I had to call for your help.

 

I have an array which I get from a MySQL query:

Array ( [id] => 1 [skill_speed] => 1 [skill_melee] => 1 [skill_kick] => 1 [skill_block] => 0 ) 

 

I need to list only the skills with values larger than 0. Without other values like [id] or [skill_block] which is 0. Need to have this output:

Skill Speed

Skill Melee

Skill Kick

 

I figure I need to use IF, FOREACH and wildcard characters but I can't make it work in an efficient way.

[cags]

foreach($array as $k=>$v) {
   if($v > 0) {
      echo $k;
   }
}

[Adam]

If the index names you wish to list always have the "skill_" prefix, you can use a foreach loop as you said:

 

foreach ($array_name as $key => $skill)
{
    if (substr($key, 0, 6) == 'skill_' && $skill != 0)
    {
        echo $skill.'<br />';
    }
}

 

As writing that though I noticed you wanted to use a label that wasn't stored in the array, which is a problem. Although you could still make this work by creating an array of labels, associated by the array key returned from the query -- if that makes sense? This may be a little over-doing it though for just 3 or 4 values. Instead you could just use a series of if statements..

 

if ($array_name['skill_speed'] != 0) echo 'Skill Speed ' . $array_name['skill_speed'] . '<br />';
(...)

[Jaret]

Thank you so much guys!!!