You're also, at the very least, going to want to escape out the characters in the HTML code that could cause problems with your query (e.g. ", '). To do this, you'd use the addslashes() function prior to inserting the data into the database. > -----Original Message----- > From: Adam Voigt [mailto:adam@cryptocomm.com] > Sent: Thursday, November 21, 2002 11:05 AM > To: mike karthauser > Cc: php-db@lists.php.net > Subject: Re: inserting html into mysql tables > > > Well for one, VARCHAR is limited to 255 characters, so I would use > a TEXT type datafield if you want to store more then 255. > > On Thu, 2002-11-21 at 11:01, mike karthauser wrote: > > hi, > > is there anything special i need to know in regards to > creating a table to > > hold html data? I am building a CMS for a site using php > and mysql. The > > various tables hold course information that the client > wants to edit. I > > imagine it will be a case of dropping the cleaned html source from > > dreamweaver into a form box and posting it to the table. > > > > What would a good varchar(?) be for say 5K of data? > > > > cheers > > mikek > > -- > > Mike Karthauser > > Managing Director - Brightstorm Ltd > > > > Email >> mikek@brightstorm.co.uk > > Web >> http://www.brightstorm.co.uk > > Tel >> 0117 9426653 (office) > > 07939 252144 (mobile) > > > > Snailmail >> Unit 8, 14 King Square, > > Bristol BS2 8JJ > > > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > -- > Adam Voigt (adam@cryptocomm.com) > The Cryptocomm Group > My GPG Key: http://64.238.252.49:8080/adam_at_cryptocomm.asc > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
