[SOLVED] Un-Signed Field Type

[ballouta]

Hello

 

What is the correct Data Type for a 'credits' field so no + or - is allowed.

For certain logic errors in my code, the credits sometimes are going -2,

I will fix my code but i also want the field to accept only Numbers.

 

Please help

 

thank you

[Ken2k7]

An unsigned int can't be negative. Is that what you're looking for?

[ballouta]

Yes, i noticed in my DB that one of teh crediys number is -2,

this field type is int(11)

 

how could it accepted this negative number?

thanks

[Ken2k7]

well int accepts both negative and positive. unsigned int is non-negative.

[ballouta]

if i am using phpmyadmin page,

is it good to add to this field the:

 

Attribute: unsigned ?

 

thanks

[corbin]

Have you read the responses at all or even made an attempt to find what the unsigned attribute does in either the PHPMyAdmin or MySQL documentation?

 

 

No offense, but people have told you a few times now.  Unsigned essentially means that numbers cannot be negative.  For example, the range of an unsigned int is 0 to 2^32-1.

 

With a normal integer, 31 bits would be value, and the least significant bit would denote positive or negative.

 

Therefore, a signed int would be -2^31-1 to 2^31-1.