Hi All, I noticed that when you return a zerofill field from a select statement into a server-side language, say PHP or Perl, it will store the number with the zeros included, great no problem.
However, if I insert into that table which has a primary key which is set as a zerofill field, when I use the PHP command mysql_insert_id() it returns the primary key value, but without the zeros, is there any way round this apart from writing some code to add the zeros? Thanks, Kevin --------------------------------------------------------------------- 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