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
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
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.
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
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
5 matches
Mail list logo