Problem in datatype

Databases
1

Hi…

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

2

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?

3

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

4

what syntax should i used for validating?

Thank you