Hi,
if I write 03719 in a ZIP field, only 3719 will be shown on the output site. How can I change it?
if I write 03719 in a ZIP field, only 3719 will be shown on the output site. How can I change it?
Nov 29, 2001, 11:23 PM
Enthusiast (907 posts)
Nov 29, 2001, 11:23 PM
Post #2 of 2
Views: 1226
Hello!
Change the property or "Attributes" of the field to ZEROFILL.
And further the property should be int(5) for the Zipcode always having five digits, in your case.
If you give int(10) in any field then then five more Zeros will be added automatically by MySQL.
Change it through PhpMyadmin or MySQLMan.
Change the property or "Attributes" of the field to ZEROFILL.
And further the property should be int(5) for the Zipcode always having five digits, in your case.
If you give int(10) in any field then then five more Zeros will be added automatically by MySQL.
Change it through PhpMyadmin or MySQLMan.