Inserting a '0' before a number

[phouchin]

Hiya i'm using mysql and have a form that takes details got it all working but I need it to be able to go into my data base so if the phone number is 0298447367 then that's what it shows in the data base .. at the moment it is shown like this 298447367 if there anyway i can fix this? (my the field is set as an int too)

Thanks peter

[kparker]

If the data type of the phone number column is 'int' then you are in trouble. Why wouldn't you just change it to text? Oh, if you are carefully (and
correctly) restricting user's data entry of phone numbers to those matching the North American Numbering scheme, (nnn-nnn-nnnn) then I guess you could just do

   printf("%010d", $phone_as_int );

and have it stick the leading zeros in, but if all the phone numbers in your database aren't exactly the same number of (original) digits then you are still in trouble.

[mp96brbj]

I believe you can add the option ZEROFILL when you create the MySQL column. (Also add UNSIGNED while you're at it. It couldn't hurt.)

However, I agree with Kirk Parker that you would probably be better off storing phone numbers as some kind of string, rather than integer.