On Tue, Feb 07, 2006 at 10:38:37AM -0800, Sam Smith wrote: > > From a <textarea> on a web form I'm attempting to convert all returns(\r), > from the users input, to "<br />", for db INSERT, and then back again for > display in the <textarea>. (They remain as <br />s for normal HTML web page > display.) You really shouldnt convert the data to br's into the database, just do it at the time at displaying it in html, and keep the raw data in the database. // add to database (prepare avoiding sql injection) $field = mysql_real_escape_string($_POST['textarea']); $sql = "update jobs set jbs_jobDesA = '$field' WHERE jbs_ID=77"; // output to html, removing xxs ablity and add html br's $field_from_db = $row['jbs_jobDesA']; echo "<div>" . nl2br(htmlentities($field_from_db)) . "</div>"; // output to a textarea, removing xxs ability $field_from_db = $row['jbs_jobDesA']; echo "<textarea>" . htmlentities($field_from_db) . "</textarea>"; This would work much nicer. No need to do any two-way convertion of your data. Curt. -- cat .signature: No such file or directory -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
