sum question

[techker]

Hey guys in my database i have a colum Retail_price in it the numbers are seperated by, so :9,245$

 

so my query

 

$q4 ="SELECT sum( Retail_price ) AS TotalCount FROM cars";
$res4 = mysql_query($q4);
$row4 = mysql_fetch_assoc($res4)

 

works but only counts the nember before ,  ....??

[kickstart]

Hi

 

Is Retail_price a numeric column, or just a character column that contains the price?

 

All the best

 

Keith

[techker]

i have it as varchar..

 

if i change it will i loose what i have in there?

[kickstart]

Hi

 

I wouldn't trust it not to lose it.

 

Short term add an extra column (say Retail_price_Numeric) and set that to equal the numeric value of Retail_price.

 

All the best

 

Keith