echo array depending on value

[owaring]

I have an array of data from db, it contains value of 1 or 0 for different fields they work in.

I only want to display the fields each person works in ie if they work in the field db value is 1.

For example this data should just display "sound"

The array is organized as so:

Array ( [0] => OLIWAR [id] => OLIWAR [1] => 1 [sound] => 1 
[2] => 0 [video] => 0 [3] => 0 [lighting] => 0 
[4] => 0 [data] => 0 [5] => 0 [projection] => 0 
[6] => 0 [racks] => 0 [7] => 0 [vision] => 0 
[8] => 0 [camera] => 0 [9] => 0 [set] => 0 
[10] => 0 [rigger] => 0 [11] => 0 [driver] => 0 
[12] => 0 [graphics] => 0 ) 

The first value is an id, in the table for linkage, and is unset from the array a few lines earlier.

The array is called $fields

I currently use a conditional statement for each field ie

if ($fields[0] == 1){echo "Sound<br>";};
if ($fields[1] == 1){echo "Video<br>";};
if ($fields[2] == 1){echo "Lighting<br>";};
if ($fields[3] == 1){echo "Data<br>";};
if ($fields[4] == 1){echo "Projection<br>";};
if ($fields[5] == 1){echo "Racks Engineer<br>";};
if ($fields[6] == 1){echo "Vision Mixer<br>";};
if ($fields[7] == 1){echo "Camera<br>";};
if ($fields[8] == 1){echo "Set<br>";};
if ($fields[9] == 1){echo "Rigger<br>";};
if ($fields[10] == 1){echo "Driver<br>";};
if ($fields[11] == 1){echo "Graphics<br>";};

However this is a bit longwinded and makes adding any extra fields to the db complicated.

My coding leaves a lot to be desired, (i only started to learn php at xmas!) however i figure i need a string that basicly does the following:

(in layman's terms!!)

$field = a 1 or 0
$fieldname = dbfield (ie sound/video/lighting etc....)

for each filed in array $fields
if $field == 1 echo $fieldname

I hope this barble makes some form of sense, i appreciate anyones time on this topic,

Many thanks,

Ollie.

[TheDefender]

[man]foreach[/man] is where you want to start probably... I am a bit tired to write out a full script that works how you want it to, but this should get you started in figuring out how it applies to what you are trying to do.

foreach($fields AS $k => $v){
    if($v == 1){
        echo $k."<br />";
    }
}

[owaring]

thanks for that,

could you explain to me what $k and $v relate to.

this echos the field name (sound/lighting etc..) but also what i assume is the number from array, as this holds a value of 1 i figure this is why its being echoed

can i add an extra condition, ie only echo if text.

[owaring]

by putting a conditional statement in it only echoes values that aren't intergers

foreach($fields AS $k => $v)
{   if($v == 1)
{if(is_int($k))
		{}else{ 
        echo $k."<br />"; 
    	}  

    } 
}

[TheDefender]

I will break it down for you: (No need for the extra conditional, just add the && (AND) clause to the if statement)

//The foreach breaks apart the array and defines the key ($k) and value ($v) pairs.
foreach($fields AS $k => $v){ 
    // If the value is equal to 1 and the key name is not a numerical value, then we echo the key name
    if($v == 1 && !is_numeric($k)){ 
        echo $k."<br />";
    } 
}