Always making Ints 2 chars long

[Peter Akrill]

Hello all,

I'm trying to create a menu bar option of posts in the past 5 months. I do
this by getting the month from date('m'), and then subtracting 1 from it
each time, However the problem is that whenever I subtract 1 it goes to
single figures, which ruins the sql query. Is there anyway to convert the
value from 6 to 06..etc?

Regards
Peter Akrill
--
/********************************************
No Electrons were harmed during
making of this message
[url]http://darkflame.sinisterkitten.co.uk[/url]
*********************************************/

[steve]

"Peter Akrill" wrote:

> Hello all,
>
> I’m trying to create a menu bar option of posts in the past 5
> months. I do
> this by getting the month from date(’m’), and then
> subtracting 1 from it
> each time, However the problem is that whenever I subtract 1 it

goes

> to
> single figures, which ruins the sql query. Is there anyway to

convert

> the
> value from 6 to 06..etc?
>
> Regards
> Peter Akrill

What is the query you are trying to execute?

--
[url]http://www.dbForumz.com/[/url] This article was posted by author's request
Articles individually checked for conformance to usenet standards
Topic URL: [url]http://www.dbForumz.com/PHP-making-Ints-chars-long-ftopict146492.html[/url]
Visit Topic URL to contact author (reg. req'd). Report abuse: [url]http://www.dbForumz.com/eform.php?p=490477[/url]

[Mr. Foo]

if( $month < 10 ){
$month = "0" . $month;
}

or you can check the length using substr and if the length
is less than 2 add leading 0


"steve" <UseLinkToEmail@dbForumz.com> wrote in message
news:413a0032$1_5@alt.athenanews.com...

> "Peter Akrill" wrote:

> > Hello all,
> >
> > I'm trying to create a menu bar option of posts in the past 5
> > months. I do
> > this by getting the month from date('m'), and then
> > subtracting 1 from it
> > each time, However the problem is that whenever I subtract 1 it

> goes

> > to
> > single figures, which ruins the sql query. Is there anyway to

> convert

> > the
> > value from 6 to 06..etc?
> >
> > Regards
> > Peter Akrill

>
> What is the query you are trying to execute?
>
> --
> [url]http://www.dbForumz.com/[/url] This article was posted by author's request
> Articles individually checked for conformance to usenet standards
> Topic URL:
> [url]http://www.dbForumz.com/PHP-making-Ints-chars-long-ftopict146492.html[/url]
> Visit Topic URL to contact author (reg. req'd). Report abuse:
> [url]http://www.dbForumz.com/eform.php?p=490477[/url]

[Janwillem Borleffs]

Mr. Foo wrote:

> if( $month < 10 ){
> $month = "0" . $month;
> }
>
> or you can check the length using substr and if the length
> is less than 2 add leading 0
>

Or just do (s)printf("%02d", $month);


JW