how to get rid of leading zeros???

[phphelp]

hi
i have several numbers which i want to store in database. but problem is that a lot of having leading zeros (zeros i the beginning) e.g 00025683 , 0025474 , 0584026 , 00000574560 etc

now i want to get rid of these leading zeros and store on;y the real number means if it is 000257060 i want it like this 257060.how to do this????

[joazito]

(my first post)

Well you could try intval():

$number_without_zeros = intval($original_number); 

Note that this only works if $original_number is an integer.
Another thing... if the field you're inserting in the database is of integer type, those leading zeros wouldn't be stored in the database.

[NeverMind]

if the field you're inserting in the database is of integer type, those leading zeros wouldn't be stored in the database.

there is an option in MySQL which is UNSIGNED_ZEROFILL..
as for casting, also this will work:

 $number_without_zeros = (int) $original_number; 

[phphelp]

thanx joazito and NeverMind and best of luck joazito as u have posted ur first post.