converting a value to a word

[Anon]

I have a field in my db called 'code' which has values A, B, and C.

I want to output this as:

If code == A
then output Apples

If code == B
then output Bananas

and so on.

What's the easiest way to do this without changing the values in the db?

thanks
chad

[djg_uk]

Hi Chad,

I'm not sure if I understand what you want to do! Do you want to output different code according to the value of the field, or do you want to know how to get the values from the database.

In the first case, using a few IF/ELSEIF statements should be fine. You could also use SWITCH CASE if that floats you boat.

If the database only has 3 different values, it isn't going to take a lot of programming!

If your question is how to grab the values from the database, post another question in the database help section.

Kind Regards,

David

[Anon]

I think the best sollution is to solve it in the SQL-statement like this:

SELECT REPLACE(code,'A','Apples') AS real_code FROM tablename WHERE code='A';

Problem is offcoourse that you can only retrieve the different code's one by one.

In PHP you could use the ereg_replace function:

echo ereg_replace('A','Apples',$code);

Good luck, i hoppe this will work for you.

grtz,
Joris

[Anon]

can you do something like this

REPLACE(code,'A','Unit Dose',code,'B','Unit Dose') AS real_code

if it has an A or a B in the column?

thanks