not updating correctly, completely wrong number

[AN-net]

well im submitting the number 7327060765 but when it passes through php and is finally placed in the database it is: 2147483647. and that is the same number in the database for any combination of numbers i use>_< can someone explain y its doing this?

my code is:

PHP Code:

    if($cellnum != $bbuserinfo['cellnum'])
    {
        if(strlen($cellnum) <> 10 OR strlen($cellnumconfirm) <>10)
        {
            eval(print_standard_error('error_badcellnum'));
        }
        if($cellnum != $cellnumconfirm)
        {
            eval(print_standard_error('error_cellnummismatch'));
        }
        if($usedcellnum = $DB_site->query_first("SELECT cellnum FROM ".TABLE_PREFIX."user WHERE userid!=".intval($bbuserinfo['userid'])." AND cellnum=".intval($cellnum).""))
        {
            eval(print_standard_error('error_cellnumtaken'));
        }
        $newcellnum = 'cellnum = "' . intval($cellnum) . '" ,' ;
    }
    else
    {
        $newcellnum = '';
    } 


i have it set it globalize() that $cellnum and $cellnumconfirm are intergers

[Zachery]

Originally Posted by AN-net

well im submitting the number 7327060765 but when it passes through php and is finally placed in the database it is: 2147483647. and that is the same number in the database for any combination of numbers i use>_< can someone explain y its doing this?

my code is:

PHP Code:

    if($cellnum != $bbuserinfo['cellnum'])
    {
        if(strlen($cellnum) <> 10 OR strlen($cellnumconfirm) <>10)
        {
            eval(print_standard_error('error_badcellnum'));
        }
        if($cellnum != $cellnumconfirm)
        {
            eval(print_standard_error('error_cellnummismatch'));
        }
        if($usedcellnum = $DB_site->query_first("SELECT cellnum FROM ".TABLE_PREFIX."user WHERE userid!=".intval($bbuserinfo['userid'])." AND cellnum=".intval($cellnum).""))
        {
            eval(print_standard_error('error_cellnumtaken'));
        }
        $newcellnum = 'cellnum = "' . intval($cellnum) . '" ,' ;
    }
    else
    {
        $newcellnum = '';
    } 


i have it set it globalize() that $cellnum and $cellnumconfirm are intergers

Whats the size of the field?

[AN-net]

field is 11 intergers

[amykhar]

Originally Posted by AN-net

well im submitting the number 7327060765 but when it passes through php and is finally placed in the database it is: 2147483647. and that is the same number in the database for any combination of numbers i use>_< can someone explain y its doing this?

my code is:

PHP Code:

    if($cellnum != $bbuserinfo['cellnum'])
    {
        if(strlen($cellnum) <> 10 OR strlen($cellnumconfirm) <>10)
        {
            eval(print_standard_error('error_badcellnum'));
        }
        if($cellnum != $cellnumconfirm)
        {
            eval(print_standard_error('error_cellnummismatch'));
        }
        if($usedcellnum = $DB_site->query_first("SELECT cellnum FROM ".TABLE_PREFIX."user WHERE userid!=".intval($bbuserinfo['userid'])." AND cellnum=".intval($cellnum).""))
        {
            eval(print_standard_error('error_cellnumtaken'));
        }
        $newcellnum = 'cellnum = "' . intval($cellnum) . '" ,' ;
    }
    else
    {
        $newcellnum = '';
    } 


i have it set it globalize() that $cellnum and $cellnumconfirm are intergers

Just for giggles, I have to wonder if the strlen is messing you up. Try doing a numerical comparison instead.

Amy

[AN-net]

how would i do that? cause i want to make sure the sure its 10 numbers long

[amykhar]

Originally Posted by AN-net

how would i do that? cause i want to make sure the sure its 10 numbers long

easy. YOu make sure it's greater than 1000000000 and less than 10000000000

Unless it can start with 0 and then you should probably make it a string and not an integer.

Amy

[AN-net]

im going to assume area codes dont start with 0...?

[Reeve of shinra]

area codes can start with zero if your dialing internationally.

011+xxxxxxxxxx whatevfer

[AN-net]

ok i guess i can it that way since currently my script only works within the US and requires no international dialing

[AN-net]

its still putting the same exact number in!