images for active /retired pilots

[mark1million]

Hi guys, sorry if this has already been covered off but what im trying to do is on the pilots list i have a column active/inactive with a gif image, what i want to do is have this updated to reflect the status of the pilot so if he is active its green and of he goes inactive or retired then this changes to red, is this possible and easily accomplished?

[Nabeel]

Yeah, use $pilot->retired

If it's 0, they're active, 1 then retired

[mark1million]

Sorry Nabeel how would i put this in to show an image?

[simpilot]

Maybe something like ->

<?php
    If ($pilot->retired == 0)
          { echo '<img src="path to your image for active" />'; }
    else
          { echo '<img src="path to your image for retired" />'; }
?>

[mark1million]

You guys are excellent

Thanks i will give that a go.