increament number leading zeroes

hi everyone,

anyone know how to increament number leading zeros and insert into mysql database..

many thanks......

 

Mind explaining more?

Incrementing numbers would be something like this:

$number = 3;
$number = $number + 1;

And inserting the number into the database would be like so:

mysql_query("INSERT INTO table (number) VALUES ('$number')") or die("Error");


Now, I have a sneaky suspicion that you are trying to set the ID for each row of your table, this is achieved by setting up a column named 'id' (or anything else, but id = easy) and setting it as Auto_Increment and then setting it as the primary key.

 

a simple padding function would used something like this

function padTenZeroes($number){// pad ten zeroes
    return sprintf("%010d",$number);
}

Code (markup):