I often find I am using a field called 'status' and almost always store boolean 1 or 0 in it, sometimes I may need a 2 or 3, but never greater than 9 for sure
For storing status codes, I would suggest using an enum type. You can give it understable status codes and can even expand it further if need arises.
-- Raj Shekhar, System Administrator Media Web India http://www.netphotograph.com
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
