[RESOLVED] Displaying my data in multiple rows

[phprooky]

Hi everyone,
I have the following data which is inserted by our director using a page that I created in php. This data is inserted using only one field.
I would like to display the data exactly the way it shows here in this example, one row under the other one. Is that possible?
December 9, 10 – Spanish/Sociales Exams
December 10 – 5:30 pm – Christmas Show
December 16, 17 – Secondary English subject area Exams
December 17 – Last day of school before the Holidays
January 11, 2010 – First day back to school after the Holidays

This is the select that I have to bring the information from my database:

$host="Host name"; 
$username="Mysql username"; 
$password="Mysql password"; 
$db_name="Database name"; 
$tbl_name="Table name"; 
 //<font face="Arial, Helvetica, sans-serif"></font>Connect to server and select databse.
$con=mysql_connect("$host", "$username", "$password"); 
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
$db_selected = mysql_select_db("$db_name", $con);
mysql_select_db("$db_name")or die("cannot select DB");

$sql= "select post from my_table order by id desc limit 1";
$result=mysql_query($sql);

$row3 = mysql_fetch_assoc($result);
mysql_close($con);

This is how I'm displaying the data right now:

echo $value['sport'] . '<br>';

[NogDog]

[man]nl2br/man, perhaps? Or put it within a set of <pre>...</pre> HTML tags?

[phprooky]

Hi NogDog and thanks for your quick reply,
The nl2br() worked very well, but I also wants to ask you if there's a way to display only the amount of rows that you wish to display, for example, if I have the following:
December 9, 10 – Spanish/Sociales Exams
December 10 – 5:30 pm – Christmas Show
December 16, 17 – Secondary English subject area Exams
December 17 – Last day of school before the Holidays
January 11, 2010 – First day back to school after the Holidays

And I only want to display the first 3 rows, is that also possible to do?

[NogDog]

Well, the "best" way would probably be to insert them as separate items into the DB and then retrieve them with a LIMIT clause. 🙂 But if you're stuck with this, you can split it into an array, then only grab the first three elements:

$arr = preg_split('/[\r\n]+/', $text, null, PREG_SPLIT_NO_EMPTY);
echo implode("<br />\n", array_slice($arr, 0, 3));

[phprooky]

Hi NogDog and thanks again for your reply,
The first line of the code you sent me goes right after my select, right? And the second line where I'm displaying the data?

[NogDog]

It would go after the fetch, adjusting variable names as needed. (I did not code it to exactly match your code.) If you prefer, you could do the implode() and/or array_slice() steps separately, assigning them to a variable, then output that variable whenever you're ready.

[phprooky]

I'm going to see what I can do because I never worked with arrays, I'm just a newbie on this, but thanks a lot for your help.