In the last episode (Aug 27), Osman Omar said: > below is my tables properties, > and my last record id is 127; > > mysql> desc emcs; > +------------+-------------+------+-----+------------+----------------+ > | Field | Type | Null | Key | Default | Extra | > +------------+-------------+------+-----+------------+----------------+ > | id | tinyint(6) | | PRI | NULL | auto_increment |
>From the manual: `TINYINT[(M)] [UNSIGNED] [ZEROFILL]' A very small integer. The signed range is `-128' to `127'. The unsigned range is `0' to `255'. What do you think happens with you hit 127? Replace that TINYINT with INTEGER. -- Dan Nelson [EMAIL PROTECTED] --------------------------------------------------------------------- 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