Page 1 of 1

Money - Price in Field

Posted: Wed Mar 05, 2003 6:31 pm
by tsg
Hey,


How do I set a row for a dollar amount?? like $2.67 .. I guess I need to set the row as a decimal .. but what do I need to put in the length - values?

Int is not work ... when I input 1.45 it goes in as 1 .

Thanks,
Tim

Posted: Wed Mar 05, 2003 6:58 pm
by Sevengraff
try using float or double instead of int

Posted: Wed Mar 05, 2003 7:38 pm
by tsg
that's exactly what I was thinking .. but what goes in the other parts of that row ?

Posted: Wed Mar 05, 2003 10:24 pm
by Sevengraff
what do you mean, other parts?
oh, like for when you create the table .. .
CREATE TABLE `money` (
`dollar` FLOAT NOT NULL
);