insert 0 in a db table

[houssam_ballout]

 

Hello

I had a mysql table with php pages related to it,

When I insert 033333 , it will take 33333, which type should I put in order to preserve the leading 0?

Thanks in advance

[PravinS]

User VARCHAR() data type

[houssam_ballout]

well,  should I need to do any trick in the php page,

cause I had changed it in the mysql,

[sader]

edit your table structure use integers type and just make sure "ZEROFILL" is checked

[houssam_ballout]

well,  in the php page, if I echo the sql statement, it displays the correct one

but when I look at the database, it won't work

if I put INT (10), with Zerofill, if I put 3 numbers, it will put 7 zeros next to it.

Any help?

Thanks

[sader]

change max available length INT (10) => int(4) then 123 will be 0123 '9' will be 0009

[houssam_ballout]

well, I know

but the numbering criteria here could vary

I just want that mysql query takes the leading 0

[sader]

Can u explane what exactly is wrong where your system fails, why u need those zeros or u just want to see them on database and be happy that 0 are there?

[houssam_ballout]

well, my form had a field for a phone number, and so, the leading zeros are being removed

[sader]

well in this case realy just use varchar as pbs sugessted.

 

or I dont' know maybe some math thrick can be used here

for example use int(10) as datatype w/o zerofill

then before storing phone number prefix it with for example 1

 

$phone = "1".$_POST['phone_number'];

mysql_query("INSERT INTO table (phone) VALUES ($phone)");

 

and when u retrive data back from database just be sure to remove that first charecter number and only then echo it or what ever you planing to do with phone number...

[Adam]

There's no use in "math tricks" (as you put it) like that. Adding the 1 at the start would void any MySQL calculations, which is generally the greatest benefit of using number types. Just store the number as a string.