> Does anyone know of an easy way to store html code in a mysql > database, and then retreive it, in such a way that it can > display the page as if it were a standard html page?
You store and retrieve html in a mysql database like you store/retrieve any other string values. You would probably want a TEXT (max 64K)or MEDIUMTEXT (max 16M) type field to store it. You would also need to escape some characters before you store the page in the database: ", ' and \ are common problems. You do not say if this is entire pages or fragments of pages. If it is entire pages, your program must output http headers, a blank line, and then the page from the database. If it is fragments, you can just output the html content on your result page like you do for any other scripts reading from mysql. > Would using php be of benefit to me? Possibly... you can't get data from mysql and output it to a webpage without some kind of scripting/programming language... and most languages may be used. Do you use a different language today? -- Roger --------------------------------------------------------------------- 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
