By definition a tinyint has a value from range -127 to 127. Try using a smallint instead. > -----Original Message----- > From: mike karthauser [mailto:mikek@brightstorm.co.uk] > Sent: Monday, December 09, 2002 9:56 AM > To: php-db@lists.php.net > Subject: Re: Enlarging tables > > > on 9/12/02 2:50 pm, Aaron Wolski at aaronjw@martekbiz.com wrote: > > > What's your table structure looks like? > > +------------+--------------+------+-----+---------+----------------+ > | Field | Type | Null | Key | Default | Extra | > +------------+--------------+------+-----+---------+----------------+ > | id | tinyint(4) | | PRI | NULL | auto_increment | > | bookcode | varchar(20) | YES | | NULL | | > | coursecode | varchar(10) | YES | | NULL | | > | date | date | YES | | NULL | | > | title | varchar(255) | YES | | NULL | | > +------------+--------------+------+-----+---------+----------------+ > > > -- > Mike Karthauser > Managing Director - Brightstorm Ltd > > Email >> mikek@brightstorm.co.uk > Web >> http://www.brightstorm.co.uk > Tel >> 0117 9426653 (office) > 07939 252144 (mobile) > > Snailmail >> Unit 8, 14 King Square, > Bristol BS2 8JJ > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
