* Chris Beasley > I tried posting this on the bug list and it rejected it. > > I've got this bug in a php script of mine and I think it's > because of MySQL. > I have a value I am inserting into a database and above and below > my query I > can echo out the value and it is correct, but the query keeps > assuming it is > "127" No matter what I do, I've renamed the variable, renamed the field, > changed my INSERT syntax a couple of times. 127, 127 ,127. MySQL is just > making up this number, there is no place it could get it.
This is a classic. :) Your field is defined as a TINYINT, an signed single byte datatype with a max value of 127. You should redifine the field type to a SMALLINT, probably even a UNSIGNED SMALLINT. <URL: http://www.mysql.com/doc/C/o/Column_types.html > -- Roger --------------------------------------------------------------------- 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