is the cost column a INT typ or VARCHAR type column. Should be set to INTEGER/ INT type column where it treats the data as a numeric type for the situation youre in.
hi, thanks for your reply, yes the cost column was set to varchar but the value was still numbers, ill try what you said and see if it works
thanks again.
EDIT: it works thanks.
EDIT2: btw i came accross another wierd problem... if the column is set to int(255) for some reason the maximum number it allows is 2147483647. when i try to set it to 1000000000000 to test it, it automatically puts it back down to 2147483647. any help appriciated