[RESOLVED] Trouble with displaying new lines from MySQL

lowe_22

Hi, I have implemented an events system on my website which allows the administrator to add/edit events etc...

Currently, these events are displayed (via a pop up window) on the homepage. However, all the new lines entered in the text area of the admin form do not show in the pop-up, causing the text to merge into one long line.

Here is the URL of the homepage: http://www.something-simple.co.uk

Here is the code I am using inside the pop-up to display the events:


<?PHP
	require("events/inc/conn.php");
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
    <meta http-equiv="content-type" content="text/html; charset=utf-8" />
<title>Something Simple - The funk band to get you in moshun!</title>
    <meta name="keywords" content="" />
    <meta name="description" content="" />
	<LINK REL="SHORTCUT ICON" HREF="somethingsimple.jpg">
<style type="text/css" media="screen">
/* <![CDATA[ */
@import url(event.css);
/* ]]> */
</style>
</head>
<body>
  <div id="content">
    <?php
	if(isset($_GET['eventID']) ) {
	$eventID = $_GET['eventID'];
	$result=mysql_query("select * from tblEvents WHERE eventID=".$eventID);

	while($row=mysql_fetch_array($result)) {

	$details=$row['eventDetails'];
	$date=$row['eventDate'];
	$venue=$row['eventVenue'];

	$details = str_replace("<BR>","<br />",$details);

	?>

<h1><span class="orangeBackground"><? print $venue; ?> Details</span></h1>
<p></p>
<h2><span class="whiteBackground"> <? print $date . " - " . $venue; ?></span></h2>
<p></p>
<p><? print $details; ?></p>
<?php
				}
				mysql_close($conn);

				}?>
  </div>
</body>
</html>

You can see i am trying to replace all the s with a to print to the browser, but it is not working. I chose the change from ' ' because that is what is listed in my MySQL entry:

" Something Simple @ Chats Palace: Chats Palace, Homerton, Hackney. Other bands include: AIRSTRIP ONE ONE SOCK BONE DEEP CRU MC DOORMATT Â£4 on door. Bring a video camera and film anything and everything for our documentory! "

For example.

Any ideas on how to get the new lines to display?

Also, how can i list the events on order of the closest date first on the home page?

Thanks

ClarkF1

You can use "ORDER BY eventDate DESC" in the query

lowe_22

Cool, thanks.
One problem with that, though, Is that the date is currently a simple text field in the input form as I did not have any ideas as to how to select a date in any other way.

Any ideas on, that, may also be of considerable help.

However, my main probelm is still outstanding...

ClarkF1

Although mySQL has it's own date functions, I just tend to store a Unix Timestamp in an Int field. This'll sort in the correct way. You can convert the current dates using mktime.

I'm not sure what your main problem is as all of my multi-line content is stored with \r\n at the end which gets put in automatically in the text-box of the form. Then when I pull the data from the database I just use str_replace on \r\n instead of the you have

\r\n isn't displayed in the database but it's there.

Where does the get inserted before the data is inserted.

Seeing the code for the insertion into the database might help

lowe_22

Thanks for the date advice, though I thought of ordering by the eventID ASC so that the last entry made to the database appears last on the list.

As far as the insertion into the database is concerned, here is the code I'm using. It also retrieves existing data if the script is passed an event Id which the user wants to edit. If there is no ID then a blank form is produced and the new entry is added.

<?php
require("inc/conn.php");
if(! isset($_COOKIE['admin'] )) {
	header("Location: index.php");
}
if(isset($_POST['btnSubmit'])) {
	$eventVenue = $_POST['eventVenue'];
	$eventDate = $_POST['eventDate'];
	$eventDetails = $_POST['eventDetails'];

if(isset($_POST['eventID'])) {
	$eventID = $_POST['eventID'];
	$sql = "UPDATE tblEvents SET eventVenue = '" . $eventVenue . "', eventDate = '" . $eventDate . "', eventDetails = '" . $eventDetails . "' WHERE eventID = " . $eventID;
	if ($result = mysql_query($sql)) {
		header("Location: home.php?action=editevent");
	}
} else {
	$sql = "INSERT INTO tblEvents (eventVenue, eventDate, eventDetails) VALUES ('" . $eventVenue . "', '" . $eventDate . "', '" . $eventDetails . "')";
echo $sql;
		if ($result = mysql_query($sql)) {
			header("Location: home.php?action=newevent");
		}
	}
}

if(isset($_GET['eventID']) ) {
	$eventID = $_GET['eventID'];
	$sql = "SELECT * FROM tblEvents WHERE eventID = " . $_GET['eventID'];
	if ($result = mysql_query($sql)) {
		$row = mysql_fetch_array($result);
		$eventVenue = $row['eventVenue'];
		$eventDate = $row['eventDate'];
		$eventDetails = $row['eventDetails'];
	}
}else{
	$eventVenue = '';
}
?>

I can't see any problems with that script as far as the new lines are concerned. You may make something more of it.

# EDIT #

I used the str_replace function you suggested (using \r\n instead of ) and it seems to have worked a treat!

Thanks very much for your help. I don't really understand the date ideas you mentioned, but I think I have found a different way to get the same effect, so all is well!

Thanks again.