Combining multiple query results into a single string

[seanl]

Hello,

I would like to combine words from different rows in a table into a single string.

from

this
is
what
I
want

to look like

this is what I want

I need the results to be available as a single variable to another part of my script.

Any one like to point me in the right starting direction?

Much appreciated.

[dagon]

CONCAT_WS()

[seanl]

Thanks,

I think I can get CONCAT_WS() to work to combine different columns in the same row, but can't figure what to do to combine the contents of 1 column from 4 rows into a single string. Does that make any sense?

[dagon]

oh i see, how are the separated? line breaks? if so replace the \n

str_replace()

[seanl]

At the moment, as far as I've got, is to extract them from the database using a select statement, and echo them out using a do / while loop. But what I really need to do, is make them available as a single string thats assigned to a variable

as I see it!

SELECT tags FROM store

$alltags = COMBINED results of SELECT STATEMENT SEPERATED WITH A COMMA

Hope that makes sense?

[dagon]

less and less clear, how about posting your current code.

[seanl]

Sorry!

OK, this is the code that selects the required data from my database

mysql_select_db($database_connCMS, $connCMS);
$query_rsCloud = "SELECT tag FROM tagcloud";
$rsCloud = mysql_query($query_rsCloud, $connCMS) or die(mysql_error());
$row_rsCloud = mysql_fetch_assoc($rsCloud);

And then this loop happily spits out the results into the body of the page

<?php do { ?>
  <div><a href="<?php echo $row_rsCloud['url']; ?>"><?php echo $row_rsCloud['tag']; ?></a></div>
  <?php } while ($row_rsCloud = mysql_fetch_assoc($rsCloud)); ?>

[dagon]

<div>
<?php do { ?>
  <a href="<?php echo $row_rsCloud['url']; ?>"><?php echo $row_rsCloud['tag']; ?></a>, 
  <?php }?>

</div>
<?php
 while ($row_rsCloud = mysql_fetch_assoc($rsCloud)); ?> 

The reason they are on a line each is they are each in a div which is a block level element so I re arranged things so they are all in one div. An html issue not a php one.

[seanl]

Sorry about that. But the html issue wasn't really my issue.

The issue for me is how to get that data that I can spit out onto the screen, into a single variable in the same format?

Appreciate your patience.

[dagon]

for ($i = 1; $i <= 10; $i++) {
    $moo .= $i.' ';
}
echo $moo;

result: " 1 2 3 4 5 6 7 8 9 10 "

[seanl]

Thank you!