On Friday, January 3, 2003, at 08:59  am, Leif K-Brooks wrote:

The limit to tinyint is 255... use int.
On Friday, January 3, 2003, at 09:02  am, Jasper Bryant-Greene wrote:

Change the field type from TINYINT to SMALLINT or MEDIUMINT. UNSIGNED TINYINT only has a range of 0 thru 255.
Thanks so much guys. I've made the change, tried again, and all is well. I opted for SMALLINT because its range is more than adequate for my needs. Whew! Relief!

Sorry for not thinking of going first to the source. Having read your posts I went back to the MYSQL manual and checked out Column Types. In my defence all I can say is that I'll remember it better this way ;-)


Jim MacCormaic
Dublin, Ireland
iChat/AIM : [EMAIL PROTECTED]


--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to