hi i
how do i do a table in a database for amount, if a user has 10.40 in there account and they buy somthing for 10 pence it changes the database table amount to this 10.3 instead of this 10.30 its missing the last digit what am i doing wrong
thanks
you’re doing nothing wrong as far as the database is concerned
if you want to show two decimal places, including the zero, then this is an issue for your front-end application
hi
i was using varchar instead of decimal. works fine now,
thanks