Hi Matt,
Thanks. That did the trick.
James
-Original Message-
From: Matt W [mailto:[EMAIL PROTECTED]
Sent: Friday, September 19, 2003 11:34 PM
To: [EMAIL PROTECTED]
Subject: Re: INSERT/UPDATE number weirdness
Hi James,
Well if you used [VAR]CHAR/TEXT and then did the INSERT query
quot;
Hope that helps.
Matt
- Original Message -
From: "James Johnson" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, September 20, 2003 1:11 AM
Subject: INSERT/UPDATE number weirdness
> Hi,
>
> This is bugging me
>
> Using PHP/MySQL.
>
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
