I am working with MySQL and PHP in Dreamweaver (thus not very experienced). I have a database I have set up that allows the user to enter in formation in a series of fields. Some fields they enter will be a number between 1-100 and other fields will be currency totals.
I would like to avoid the entry of negative numbers. How would i define the data fileds for this?
And lastly, do they need to enter the currency in decimals? Or can they just enter 1000 for 1000.00
I've got all fields related set to Int except for the currency fields where I am using Decimal(10,0)