Hello I am trying to create a graphic grid that will update the graphics according to what is in a paticulare field within a mysql table.
The grid is a representation of a theater seating section with lets say 50 seats. If the Ticket is available for a paticular seat, then the graphic on the grid associated with that seat would be Green. If the ticket has been sold then the graphic is red.
Cuurently I have been able to get the graphic to update with the following code.
<?php echo RegExpMatch ($Graphics->Value("Status"), "Sold", true, "<img src=images/red.gif>", "<img src=images/green.gif>")?>
Now here is the problem. The above code works great if there are only two options in the Status Field, Sold and Available, but there are four possible options in the Status Field. They are as follows; Sold, Available, Season Holder and No Sale.
I would like to replace the graphic with a blue image if the ticket is a Season Holder Ticket and replace the graphic with a black image if the Ticket is a No Sale Ticket.
How would I or what would I do to the above code to get it to work with the four options.
Thanks
Stan Forrest