In my database schema,
for one fiels "exp" i have made it as float(3,2)
it stores value properly up to 9.99
but for then it goes out of range and stores 9.99
whats wrong in this?

i expect it store values up to 999.99
but it stores uo to 9.99

what i have missed/wrong in this?

Sorry guys..
i was wrong
It was my (stupid) thought that 3 is number of digits before '.' and 2 is after '.'
but its actually
3 is number of total digits.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.