Leading zero being removed

[renno]

When I upload a telephone number field to an SQL database, for example 01898543251, the leading zero is removed and becomes 1898543251. Is there a numeric type that keeps the leading zero or does it have to be inserted as a type of string?
Any help would be much appreciated...

Cheers,

[Daniel0]

If your number is always 11 digits long then you can do this:

[code]<?php
$number = 6848;
$length = 11;

if(strlen($number) < $length)
{
for($i=0; $i<11-strlen($number); $i++)
{
$prepend .= "0";
}
$number = $prepend.$number;
}
echo $number;
?>[/code]

[zq29]

I don't think there is a specific numeric datatype that will preserve leading zeros. Either store it as a string, or as an integer and restore the zeros when displying as in Daniel0s reply. You can also do it with str_pad()
[code]<?php
echo str_pad ("1234",11,"0",STR_PAD_LEFT); //Displays 00000001234
?>[/code]

[renno]

thanks loads, will give it a go...

[Daniel0]

[quote author=SemiApocalyptic link=topic=112007.msg454288#msg454288 date=1161258777]
You can also do it with str_pad()
[code]<?php
echo str_pad ("1234",11,"0",STR_PAD_LEFT); //Displays 00000001234
?>[/code]
[/quote]

Great, I must remember that trick. Much easier than my method.