Hi, This is bugging me....
Using PHP/MySQL. I have three input fields to hold a user's phone number. The MySQL fields are set to SMALLINT. If any of the strings to update the DB starts with a 0 (zero), the first number is truncated (0206 becomes 206). Any other combination where the first digit is not a 0 works. I have tried both $tr_p1SUF = $_POST['phone1SUF']; "...SET phone1SUF = '$tr_p1SUF'..." AND "...SET phone1SUF = $tr_p1SUF..." I have tried changing the DB field types to char, int, text, varchar Idea, suggestions? Thanks, James -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
