RE: [PHP] Newbie Question

store the data in the database with the newlines, then when you're printing out the values, use the nl2br() function: http://php.net/nl2br jack -----Original Message----- From: Jay Fitzgerald [mailto:jayfitz@bayou.com] Sent: Thursday, November 08, 2001 10:54 AM To: php-general@lists.php.net; php-db@lists.php.net; mysql@lists.mysql.com Subject: [PHP] Newbie Question Importance: High 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 General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net For additional commands, e-mail: php-general-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net