I think certain types of INT fields (not sure which ones) zero fill the
number to the field length... you should read up on the col types, and maybe
change it over. Maybe do a search on "zerofill" / "zero fill".
Anyhoo, to solve your immediate problem, you could check the length of
$row[main_group], and add some zeros to the start of it, until it's length =
your desired length.
<?
// UNTESTED
$row[main_group] = "45";
$desiredLength = 4;
while(strlen($row[main_group] < $desiredLength))
{
$row[main_group] = "0".$row[main_group];
}
?>
I'm sure there are other ways, and it'd be best if you wrapped it in a
function :)
Justin French
on 11/06/02 1:11 PM, César L. Aracena ([EMAIL PROTECTED]) wrote:
> Hi all,
>
> Does anyone remembers how to add zeros in front of a result number given
> by a query to MySQL and returned as an array, so it always shows a 4
> digit number? I have:
>
> [snip]
> echo $row[main_group]."/".$row[sub_group];
> [snip]
>
> but throws out:
>
> 1/0
> 2/0
> 3/0
>
> instead of:
>
> 0001/0
> 0002/0
> 0003/0
>
> which it should. Thanks in advance,
>
> Cesar Aracena <mailto:[EMAIL PROTECTED]>
> CE / MCSE+I
> Neuquen, Argentina
> +54.299.6356688
> +54.299.4466621
>
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
