display unsigned zerofill autoincrement value without leading zero
- by I Like PHP
my primay key is user_id which is auto incremant UNSIGNED ZERO FILL, i want to display user_id on a page without leading Zero( means 1 instead of 0000000001 )..
how can we do that in php or in mysql
one more question...
if i delete last record( let user_id=21) wwhich have highest id of that table then can we adjust auto increment value to 21 instead of 22 of that table.