thanks for the help but i am a newbie to PHP and mySQL i tried to use
nr [tinyint(10) or int(10)] [UNSIGNED] [ZEROFILL] [No] [auto_increment ]
and when i give value to nr as 1 it always take as 0000000001
so i dont no how to reduce these much zeroes i want as 001 or please help me to write the function using PHP or how i can directly fill 001 in database.
I will be very thankful ......