Re: [PHP] PHP/mySQL dropping zeros after inserting number into record

2008-02-18 Thread Richard Lynch
On Sat, February 16, 2008 5:22 pm, Rob Gould wrote: > I've got a PHP script that inserts "00012345678" into a record in a > mySQL database (it's a barcode). Things work ok unless the number has > preceding zeros, and then the zeros get cut off and all I get is > "12345678". > > I have the mySQL da

Re: [PHP] PHP/mySQL dropping zeros after inserting number into record

2008-02-17 Thread Nathan Rixham
Daniel Brown wrote: On Feb 16, 2008 6:22 PM, Rob Gould <[EMAIL PROTECTED]> wrote: I've got a PHP script that inserts "00012345678" into a record in a mySQL database (it's a barcode). Things work ok unless the number has preceding zeros, and then the zeros get cut off and all I get is "1234567

Re: [PHP] PHP/mySQL dropping zeros after inserting number into record

2008-02-17 Thread Daniel Brown
On Feb 16, 2008 6:22 PM, Rob Gould <[EMAIL PROTECTED]> wrote: > I've got a PHP script that inserts "00012345678" into a record in a mySQL > database (it's a barcode). Things work ok unless the number has preceding > zeros, and then the zeros get cut off and all I get is "12345678". > > I have th

Re: [PHP] PHP/mySQL dropping zeros after inserting number into record

2008-02-16 Thread Emilio Astarita
Rob Gould <[EMAIL PROTECTED]> writes: > I've got a PHP script that inserts "00012345678" into a record in a > mySQL database (it's a barcode). Things work ok unless the number has > preceding zeros, and then the zeros get cut off and all I get is > "12345678". > > I have the mySQL database fieldt

RE: [PHP] PHP/mySQL dropping zeros after inserting number into record

2008-02-16 Thread Bastien Koert
char(14) is a better data type bastien > Date: Sat, 16 Feb 2008 15:22:17 -0800 > From: [EMAIL PROTECTED] > To: php-general@lists.php.net > Subject: [PHP] PHP/mySQL dropping zeros after inserting number into record > > I've got a PHP script that inserts