> hi ,
>
> i have some mysql tables in my mysql database . It is included "status" field .
> In the status field , it is maintainig "up" , "down" status.
> SO i want to add colors for this status.
> up = green
> down = red
> how can i do that ? can some body help me ..........plz
I think this question will be better answered on a list for the language you're using
to access MySQL.
However, if you want to do it from MySQL:
SELECT
CASE status
WHEN "up" THEN "green"
WHEN "down" THEN "red"
END AS status_color
FROM table
Regards,
<mack />
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
