I want to be able to add a number field to a table and limit the values that the user can enter. For example if it is an integer filed I may want the user to only enter the value from 1 to 10. Can I do this within the definition of the field/table or do I have to do this level of validity checking in whatever method I use to allow input (most likely PHP/HTML). Thanks, David --------------------------------------------------------------------- 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