on updating any field from dropdown list into MYSQL with white space, data gets truncated
<p>I'm working on PHP and MySQL. inserting data and even retriving them are all fine. when i insert any data from dropdown list works fine and i can see data correctly inserted. if i dont change any data in the dropdown list and simply click on update button then those data having white space or / get truncated. for example:  red rose or red / rose  after clicking on update button becomes red. this is only happens when i try to update from dropdown list otherwise from text-box or text-area i have no problem even if i use apastrophe or / or white space. </p>
