Показване на брояч така 000001:999999

[talevtehnology]

Как мога да направя този брояч да брои не така 1,2,3.....10,11 ами така
000001,000002,000003.....000010,000011

ето и кода

<?php 
$host="localhost"; // Host name 
$username=""; // Mysql username 
$password=""; // Mysql password 
$db_name="test"; // Database name 
$tbl_name="members"; // Table name 

// свързва се към база данни. 
mysql_connect("$host", "$username", "$password")or die("cannot connect to server "); 
mysql_select_db("$db_name")or die("cannot select DB") 

$sql="SELECT * FROM $tbl_name"; 
$result=mysql_query($sql); 

$rows=mysql_fetch_array($result); 
$counter=$rows['counter']; 

// if have no counter value set counter = 1 
if(empty($counter)){ 
$counter=1; 
$sql1="INSERT INTO $tbl_name(counter) VALUES('$counter')"; 
$result1=mysql_query($sql1); 
} 

echo "You 're visitors No. "; 
echo $counter; 

// count more value 
$addcounter=$counter+1; 
$sql2="update $tbl_name set counter='$addcounter'"; 
$result2=mysql_query($sql2); 

mysql_close(); 
?>

 

[Karcho]

$var = sprintf("%06s\n",$counter);