Re: [PHP-DB] Enlarging tables

2002-12-09 Thread mike karthauser
on 9/12/02 2:58 pm, Hutchins, Richard at [EMAIL PROTECTED] wrote: > Premature clickage... > > Or you could use a mediumint or int. Just check the mysql manual and select > the int type that suits the size of your db best. Ta. Thats working now. Thanks from a 3 week old newbie. -- Mike Karthaus

RE: [PHP-DB] Enlarging tables

2002-12-09 Thread Hutchins, Richard
7;mike karthauser'; [EMAIL PROTECTED] > Subject: RE: [PHP-DB] Enlarging tables > > > By definition a tinyint has a value from range -127 to 127. > Try using a > smallint instead. > > > -Original Message- > > From: mike karthauser [mailto:[EMAIL PROTECT

RE: [PHP-DB] Enlarging tables

2002-12-09 Thread Hutchins, Richard
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 >

Re: [PHP-DB] Enlarging tables

2002-12-09 Thread mike karthauser
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 | ++--+--+-+-+--

RE: [PHP-DB] Enlarging tables

2002-12-09 Thread Hutchins, Richard
What kind of table? Can you provide your table creation script or the output of mysql>describe tablename; > -Original Message- > From: mike karthauser [mailto:[EMAIL PROTECTED]] > Sent: Monday, December 09, 2002 9:48 AM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] Enlarging tables > > > W

RE: [PHP-DB] Enlarging tables

2002-12-09 Thread Snijders, Mark
http://www.mysql.com and check 'alter table' with this you can fix it but using phpmyadmin or another program is more handy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Enlarging tables

2002-12-09 Thread Aaron Wolski
What's your table structure looks like? Aaron -Original Message- From: mike karthauser [mailto:[EMAIL PROTECTED]] Sent: December 9, 2002 9:48 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Enlarging tables We have been entering data into a mysql table and it has got to id=127 and then stopp