Image based on MySQL data...HELP Please

[cmaclennan]

Hi All,

 

I have a question and im really not sure where at all to begin. What I would like to achieve is a basic page that can have a list of stores on it and next to the store either a green, yellow or red icon to show it's status. It sounds fairly simple and i could very well just be going through a bad case of brain freeze but any insight and help on getting this done would be appreciated.

 

Thanks in Advance.

[cags]

$result = mysql_query("SELECT * FROM table");

while($row = mysql_fetch_assoc($result)) {
   echo $row['store_name'];
   echo "<img src="' . $row['status'] . '.jpg" />';
}