RE: [PHP] Adding zeros in front
| From: | Martin Towell | Date: | Tue, 11 Jun 2002 03:27:28 +0000 |
| Subject: | RE: [PHP] Adding zeros in front | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-101495@lists.php.net to get a copy of this message | ||
$num2 = sprintf("%4d", $num);
the "d" might have to be something else, can't remember
-----Original Message-----
From: Justin French [mailto:justin@indent.com.au]
Sent: Tuesday, June 11, 2002 1:20 PM
To: César L. Aracena; PHP General List
Subject: Re: [PHP] Adding zeros in front
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 (caracena@infovia.com.ar) 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:webmaster@icaam.com.ar>
> 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