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 database

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 the mySQL

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 12345678.

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

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 fieldtype set to