Thanks in advance,
Tom
*The offending code:*
}elseif($_REQUEST['add']){
$desc = $_REQUEST['description'];
str_replace("\r\n\r\n", "<p>", $desc);
str_replace("\r\n", "<br>", $desc);
$result = mysql_query('INSERT INTO hr_listings (title,description,location,end_date,posting_date) VALUES("'.$_REQUEST['title'].'","'.$desc.'","'.$_REQUEST['location'].'","'.$_REQUEST['end_date'].'", NOW())',$db)
or trigger_error("MySQL error nr ".mysql_errno().": ".mysql_error());
*Output of mysql_dump showing the \r\n's going in*
INSERT INTO hr_listings VALUES (15,'test',5,'2003-06-16','2003-09-11',NULL,'This
is one line\r\nThis is the next\r\n\r\nThis is another paragraph\r\n\r\n');
INSERT INTO hr_listings VALUES (16,'test2',1,'2003-06-16','2004-09-11',NULL,'Thi
s is one line\r\nThis is the next\r\n\r\nThis is another paragraph\r\n\r\n');
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php