Ok, I think I have the solution to your problem. Try using nl2br() on the data in that field.. Example:
I have a message table that allows one user to send an instant message to another user on my site. There are several fields, one of which being a TEXT column (MySQL db). I use a simple textarea form element to get the data. It inserts into the DB as basically a single line regardless of the ENTER keystrokes in the data. Now, when I pull it back out I use this: $query = "SELECT * FROM message WHERE msg_id = '$msg_id'"; $query_result = mysql_query($query); $query_row = mysql_fetch_array($query_result); $message = $query_row["message"]; echo "Message text:".nl2br($message); And that should do what you need. Lee Willmann "Steve Brett" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > have a look at get_html_translation_table() in the php manual. > > there is an example of conversion of all special chars so they can be > inserted into the database as text (i.e. £>£) and a cool way of > 'decoding' them if you need to write them to a file. A Browser wil interpret > them correctly when they are displayed. > > This must be the question of the day as i have posted this answer three > times today :-) > > Let me know if you need any more help > > Steve > > get_html_translation_table manual page is below: > > PHP Manual > Prev Next > > -------------------------------------------------------------------------- -- > ---- > > get_html_translation_table > (PHP 4 >= 4.0b4) > > get_html_translation_table -- Returns the translation table used by > htmlspecialchars() and htmlentities() > Description > > string get_html_translation_table (int table [, int quote_style]) > > > get_html_translation_table() will return the translation table that is used > internally for htmlspecialchars() and htmlentities(). There are two new > defines (HTML_ENTITIES, HTML_SPECIALCHARS) that allow you to specify the > table you want. And as in the htmlspecialchars() and htmlentities() > functions you can optionally specify the quote_style you are working with. > The default is ENT_COMPAT mode. See the description of these modes in > htmlspecialchars(). Example 1. Translation Table Example > > $trans = get_html_translation_table (HTML_ENTITIES); > $str = "Hallo & <Frau> & Krämer"; > $encoded = strtr ($str, $trans); > > > > The $encoded variable will now contain: "Hallo & <Frau> & > Krämer". > > The cool thing is using array_flip() to change the direction of the > translation. > > > $trans = array_flip ($trans); > $original = strtr ($str, $trans); > > > > > The content of $original would be: "Hallo & <Frau> & Krämer". > Note: This function was added in PHP 4.0. > > > See also: htmlspecialchars(), htmlentities(), strtr(), and array_flip(). > > > -------------------------------------------------------------------------- -- > ---- > Prev Home Next > explode Up get_meta_tags > > > > > > "Jay Fitzgerald" <[EMAIL PROTECTED]> wrote in message > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > Ok, I am still fairly new at PHP and MySQL also, so please bear with me. > > > > > > TASK: I have a client that wants to have job openings listed on their site > > and they want to be able to add, edit and delete the postings themselves. > I > > would do this in flat-file format but there is the risk of that file size > > getting too large and slowing down the server. > > > > > > SOLUTION: I have created a MySQL database that will hold all the postings > > in a table called 'jobs' and have created a PHP form that will post this > > jobs into the db. > > > > PROBLEM: When I go to the PHP form and enter all of the pertinent job > > information, there is one specific field that will have to have carriage > > returns/line breaks in it between paragraphs. Everything is working except > > for this. Is there a way whenever the user presses <ENTER>, that either > > PHP/MySQL will convert this into a <BR> tag only when being displayed in a > > browser and not in the db?? > > > > > > Can anyone out there please help me with this? I am available off-list as > > well if it will be easier to pass code back and forth. Any assistance is > > greatly appreciated! > > > > > > > > Should you have any questions, comments or concerns, feel free to call me > > at 318-338-2034. > > > > Thank you for your time, > > > > Jay Fitzgerald, Design Director - CSBW-A, CPW-A, CWD-A, CEMS-A > > ========================================================== > > Bayou Internet..............(888) > > 30-BAYOU........................http://www.bayou.com > > Mississippi Internet.......(800) > > MISSISSIPPI...............http://www.mississippi.net > > Vicksburg Online..........(800) > > MISSISSIPPI................http://www.vicksburg.com > > ========================================================== > > Tel: (318) 338-2034 ICQ: 38823829 Fax: > > (318) 323-5053 > > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
