converting a value

[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.

I've tried this and it works for a single value but no more:

$query = mysql_query("SELECT color, size, REPLACE(code,'A','Apple') AS real_code FROM products

Does anyone know how I can do thing:

$query = mysql_query("SELECT color, size, REPLACE(code,'A','Apple',code,'B','Banana') AS real_code FROM products

When I do this one it errors out on me.

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

thanks
chad

[cordex]

Have you tried this (I don't know that it will work but give it a try):
$query = mysql_query("SELECT color, size, REPLACE(code,'A','Apple') AS real_code, REPLACE(code,'B','Banana') AS real_code FROM products");

[Anon]

I tried that and it didn't work.

Could I do it like this?

Note: code = the name of db column

if ('code == A') {
$codeoutput = ("Apples");
}
if ('code == B') {
$codeoutput = ("Banana");
}
if ('code == C') {
$codeoutput = ("Cherry");
}

Then output the $codeoutput???

If so what looks wrong with is could. getting errors.

[cordex]

$str_st = "SELECT * FROM products";
$result_rs = mysql_query($str_st);
while($result_ar = mysql_fetch_array($result_rs))
{
if ($result_ar['code'] == 'A') {
$codeoutput = ("Apples");
}
if ($result_ar['code'] == 'B') {
$codeoutput = ("Banana");
}
if ($result_ar['code']== 'C') {
$codeoutput = ("Cherry");
}
}