all digits to be as pairs?

[RON_ron]

How do I get the number as pairs? (i.e. 05, 20, 01, 70)

 

$query = "SELECT statez, COUNT(statez)FROM distributors GROUP BY statez";

 

$result = mysql_query($query) or die(mysql_error());

 

while($row = mysql_fetch_array($result)){

echo $row['COUNT(statez)'] ." Distributors in ". $row['statez'];

echo "<br />";

}

?>

[Adam]

You mean with the leading zero? That would depend how you're storing the number, what data type is the column?

[RON_ron]

varchar

[mraza]

i think if u do that with decimal it would work but as a simple fix i used this once

 

$var = ($num<10) ? "0$num" : $num;

[Adam]

Just use str_pad.

[RON_ron]

Thanks Mr.Adam.