i've changed the table field of 'designation' type from enum to varchar(20) and its work. By the way, changing the table name from designation to id didnt do any changes and still appear the 'data truncated' error to my webpage. I want the type to be 'enum' rather than varchar. Please help me on this...