concat function is not working

[phprock]

Hello,

Here is query

$result=mysql_query("select concat('km',car_miles),car_price from car ",$link);
while($row=@mysql_fetch_array($result)){

echo"$row[car_miles],$row[car_price]";
}

i get $row[car_miles]= 0, but i get right $row[car_price]

why I am not getting the right values of car_miles..

I want to display car miles as . ie.

123,445 Km

[njm]

SELECT concat('km',car_miles) [COLOR=blue]AS car_miles[/COLOR] ...

hth, njm