SQL Question - Column Datatype

[boomers]

I've tried an integer column and a decimal column but whenever I try to input the figure '11.50' it automatically changes it to '12'.

I'm also using the SUM() function on these columns so using varchar or something similar isn't an option.

I cant see why my figure changes within an integer or decimal column.

 

[Ray]

What does your PHP code look like?

 

[Kate]

Just declaring the field as decimal is not enough, you need to provide scale/precision, example: decimal(6,2) makes room for 2 decimals.

 

[boomers]

Just declaring the field as decimal is not enough, you need to provide scale/precision, example: decimal(6,2) makes room for 2 decimals.

This was indeed the problem, appreciate your reply