Hello.. I am having a problem reconfiguring a field. This menu select puts $type into a varchar(6) field. Type:<SELECT NAME='type'> <OPTION SELECTED>$type <OPTION>Regula <OPTION>Servic <OPTION>Open </SELECT> The record and field is loaded and everything works fine until I try to change it to varchar(7). After I edit the field to 7 characters, I get an error: Warning: Supplied argument is not a valid MySQL result resource in f:/localhost/company_input.php3 on line 19 when it tries to pull the record. There are two tables using the same script and the table that was not changed to 7 characters continues to work. So is it safe to say it is the record that is bad and not the script? What is happening to the field and/or record which causes it to crash and more over, when I return it to varchar(6), it doesn't want to go back to normal as it should. I have been refreshing, restarting Apache and mySQL and *sometimes* it starts to work again but I haven't been able to figure out what's going wrong and why. Once it's been changed it gets damaged in some way that's hard to correct. This is running on win32. TIA for any fix or ideas. Floyd -- --------------------------------------------------------------------- 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
