Problem in datatype


I input numbers in textboxes.
When I did not input number in my textbox or textbox is blank and i click save it save as 0.00 I used double data type.

I want to happen is if I did not input number or data in my textbox no datra will save in my database.

THank you

I believe that if you are using Double as the column type, the attribute is: ZeroFill. I don’t know if there is a way around it via the database?

That kind of validation must be done in your PHP code. You only execute the insert query when all values are correct.

what syntax should i used for validating?

Thank you