Re: Formatting Large amounts of Text into Mysql

2001-10-24 Thread Kodrik
I use this function to cleanup my text. It converts any weird characters that may cause problems when outputting to html with php. It also converts end of line to or depending on your version of php function cleanup($copy) { $copy=trim($copy); $copy=htmlspecialchars($copy, ENT_QUOT

Re: Formatting Large amounts of Text into Mysql

2001-10-23 Thread Carl Troein
tim gales writes: > Hi. I am trying to have type in a story into a form "textfield" and > submit it using PHP into "blob" formatted field mysql database. > > When I submit, all the "returns" are removed and all the text runs > together like on ebig paragraph. Is there a way to have mysql or P

RE: Formatting Large amounts of Text into Mysql

2001-10-23 Thread Steve Meyers
Are you sure it doesn't have the line feeds in the database? Neither MySQL nor PHP will strip them out, unless you do some fancy work to make it do that. I would guess that your real problem is that when you display it in your HTML, it shows up without "returns". This is standard HTML practi