sometimes number defaults to something else

[cornercuttinjoe]

i have noticed something weird.

i am working on an order manager, and part of the database has a table that holds phone numbers and some other information.

i have noticed that a lot of times, no matter what i put into the php page, when i query the database, the phone number always comes back as 4294967295.

does anyone know why this happens?

the number 4294967295 never appears in my code anywhere, but it shows up in the database every so often.

any clue on why this happens?

thanks.

[cornercuttinjoe]

its doing it again.

in the middle of this form, i did an echo of the phone number, it comes out right, and then i even echo'd the query that i was using to put the data into the database, and the information is right for everything, but for some reason, the database is trying to insert this 4294967295 value. what is weird is if i remove any entries with this 429... number, then everything runs smoothly. just every now and then, it acts up, and then once it does, you cant put anything into the table without removing this 429... tuple.

here is what i have done...

$query = "INSERT INTO btn (btn_phone_number, btn_tax_exempt, btn_lpc_exempt, btn_directories, listed_address_num) VALUES ('$btn', '$tax_exempt', '$lpc_exempt', '$directories', '$address_num')";
echo '<p>The btn insert i am trying is ' . $query . '</p>';
$result = @mysql_query($query);

like i said, no matter what the value of this $btn is, it still is trying to insert the 429... number. when i echo the query, it all looks right. so i know that the query is right when i try to insert it, but for some reason, something is messing up.

anyone have any ideas?

[Roger_Ramjet]

2 possibilities come to mind

column type is 'set' or 'enum', and the 429... is one of the specified values
column default value (unlikely but possible)

[jansky]

check your table maybe Roger is right