[Resolved] Inserting Zip Codes that start with 0

[Cole_PD]

This question has probably been asked several times before, but here it goes again:

I'm trying to get my program to enter a zip code starting with a 0 (zero) into the database, but MySQL refuses to include it in the database. The zip code ends up being just four numbers without the zero in front. How can I get around this?

[AstroTeg]

Sounds like your field type is set as an integer. Set it to text or varchar and you'll find it'll hold onto the leading zero.

[TheDefender]

Alternately, if you don't want to or can't change your field type, you can always use [man]str_pad[/man] to add 0's back onto the front when you pull them out...

[Cole_PD]

Thanks, guys! Problem solved.