Result merged into one.

[ph34rl3ss]

Hi there,

 

I hope anybody can help me or point me in the right direction.

 

I would like to do the following with a mysql query:

 

SELECT title FROM post

 

Gives lets say 60 + results.

 

1) First post

2) Yeah it works

and so on ...

 

Now I would like to get all the results and merge them into one.

 

1) First post Yeah it works ....

 

So that it becomes one long text.

How can I achieve this?

 

Thank you reading and hopefully helping me

 

Greetings,

 

Jeroen

[dreamwest]

1) First post

2) Yeah it works

 

If 1) , 2) etc are rows, Dont use a <br> after $row

 

$query = "SELECT * FROM example"; 

$result = mysql_query($query) or die(mysql_error());


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

echo $row['title'];
}

[fenway]

Short answer... don't format your output in mysql.