Re: 4 Digit ID with Leading Zeros
| From: | John Hinton | Date: | Thu, 15 Dec 2005 16:01:27 +0000 |
| Subject: | Re: 4 Digit ID with Leading Zeros | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-227475@lists.php.net to get a copy of this message | ||
Rahul S. Johari wrote:
Ave, I'm looking into the ZEROFILL option now. Didn't know about it before but it looks promising and probably is my solution. I'll get back. Thanks a ton! On 12/15/05 10:24 AM, "Jim Moseby" <JMoseby@nrbindustries.com> wrote: Zerofill in mysql will do it. But, many mysql 'clients' don't 'display' the zeros. As best that I remember, phpMyAdmin does show the zeros, so be careful as what you 'see' might not really be what you 'get'. Seems like there are issues with the viewing of this in Excel as well.. Friggin programs that think they are smarter that people!!!!Anyway, that'll do the mysql side of it for you. John Hinton