An integer set to plave a zero in front of single numbers?

[brad62]

I have a drop down menu in php that is inserting numbers into a mysql table.
But when numbers between 1-9 are inserted I want them to add a zero in front, so that all numbers in the table are set to 2 figures.

Guess it's simple, but just don't remember how to do it.

[r937]

use php to append the zero -- it's a display issue, not a database issue

[brad62]

So I should do something like an if statement to put a zero in front of everything less than 10?
Isn't there just a way to make the db save it as 2 numbers all the time?
Think I read that sometime...

[r937]

yes, do it with php

there is a way to make the database save 2 digits, but that requires converting the column to VARCHAR, which means you won't be able to use auto_increment (if that's what you're using)

[brad62]

No, I have listed a couple of numbers between 1-25.
But I might wanna use them to add numbers to in the future, but maybe it's possible even if it's a VARCHAR?

[r937]

i say again, you should really be doing this in php

select right(concat('00',yourcolumn),2) as yourcolumn_with_leading_0_if_necessary ...

[brad62]

If I want to put a month number into a db and be sure it's input with 2 figures. How do I do that?

Let's say I want to input month 03 so I can use it in a 2007-03-03.
That would be something similar I guess. Then I wouldn't add the zero in php.

[r937]

If I want to put a month number into a db and be sure it's input with 2 figures. How do I do that?

as VARCHAR

Let's say I want to input month 03 so I can use it in a 2007-03-03.
That would be something similar I guess. Then I wouldn't add the zero in php.

you don't need it in mysql there either

[BrandonK]

Believe Rudy, it's 100% display. You are just adding the 0 for looks, so do it in PHP.

$padded = sprintf("%02d", $unpadded);

That will pad $unpadded to 2 positions, using 0's.

Read More: http://www.php.net/manual/en/function.sprintf.php