By definition a tinyint has a value from range -127 to 127. Try using a smallint instead.
> -----Original Message----- > From: mike karthauser [mailto:[EMAIL PROTECTED]] > Sent: Monday, December 09, 2002 9:56 AM > To: [EMAIL PROTECTED] > Subject: Re: [PHP-DB] Enlarging tables > > > on 9/12/02 2:50 pm, Aaron Wolski at [EMAIL PROTECTED] 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 >> [EMAIL PROTECTED] > 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
