Replacing text with images

[Bravogolf]

I have approx 12 fields being returned to a user from a table within a MySQL database.

One of the tables will always contain one of three possible values (Sold, Rejected or Outstanding) within the status field. When I return all the information to the user, I would love to be able to replace the status field with an image. So if it was marked as Sold, a tick would be there, or an X for Rejected, for example.

I imagine I need to use an array or something but I've no idea and was hoping maybe one of you genii could help?

 

[Vragabond]

You could just use switch structure:

switch ($row['status'])
{
  case "Sold":
    echo '<img src="sold.gif" alt="Sold" />';
    break;
  case "Rejected":
    echo '<img src="rejected.gif" alt="Rejected" />';
    break;
  case "Outstanding":
    echo '<img src="outstanding.gif" alt="Outstanding" />';
    break;
}

Of course you may have to tweak the code to make it work for you.

 

[Bravogolf]

You're brilliant

I'm relatively new to using PHP (up until now I only really availed of the include function) and did not know how to pass the Status into a switch

Thank you very much.