Host unlimited blogs, websites for $4.95 only with this web host
or order a planet alpha dedicated server for less than $50 here

Hostgator and Bluehost are our best webhosts and godaddy.com is the best domain registrar.

This web hosting thread started by Dabsphere on 15 September 2008

I need 4 fields within my PHP application to be updated:

1- Name
2- Business Name
3- Website
4- Describe Your Business

The update command works fine for the first 3 fields but I’m not able to update the 4th field using the update command.

$query=”update userinfo set
name=\”$name\”,business=\”$business\”,website=\”$website\” where
username=\”$username\”";

WORKS FINE , but when I include the describe field i.e

$query=”update userinfo set
name=\”$name\”,business=\”$business\”,website=\”$website\”,describe=\”$describe\”
where username=\”$username\”";

when I perform the above operation, I can’t edit any fields, that means update command doesn’t work anymore.

I have discussed this with other PHP developers and came to know that, update command wont works fine in some cases. I feel the problem is in the server data type settings for “describe” field. I’ve set data type for “describe” field as varchar(5000). I heard from my friends that for long descriptions we may need to set the data type as “BLOB” or “TEXT” and I tried them too, but it didn’t help.

Any assistance regarding this matter will be greatly appreciated. Thank you in advance.

Discuss this at WHT or read more about bluehost and hostgator

• phpFormGenerator Web Hosting
• Bluehost : Which sql datatype to use for drop downs and checkboxes
• Web Hosting : Update httpd and my website lost?
• Bluehost : help mysql password()
• Bluehost : FTP Headache
• Bluehost : How to set cron job
• Web Hosting : Something really weird… what could cause this?
• Bluehost : PHP Script error
• Web Hosting : [Ajax] Form Textbox Style Change
• Web Hosting : MySQL: Primary Keys in Views via Describe

This web hosting blog is proudly hosted with reliable Hostgator webhosting for only one cents through this hostgator coupon. If you're new here, you may want to subscribe to this web hosting RSS feed