At 15:00 -0800 2/26/02, Scott Broderick wrote: >Hello group! I am a newbe to this listing. > >What I am attempting to do is pass a number like "0123456" to a field in the >mysql database which is setup as int(11) but for some reason, the zero is >not >written into the database but instead all that is written into that field is >"123456" >What am I doing wrong? Can someone help me please? Thanks
Perhaps you should use the ZEROFILL attribute when you specify the column definition. However, you'll have to declare it at INT(6) ZEROFILL, not INT(11) ZEROFILL if you want it to display with six digits. > > >Scott Broderick --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
