Multiple fields - how to combine??

[tenderosity]

hi -

is there a code example on how to select 3 rows's fields - lets say - there is a same user id - but has 3 different rows with different values which came from name, middle name, and last name which came from 3 different forms - and i want to pull them all out in one query from db then use it as a new value for another table's row field -

example:

select with query following 3 fields (one from each of 3 rows):

john

gary

black

then once it is combined by query - it should look like this

john gary black

just one line value (not 3 anymore)

and then update another field in another row of another table with the new value of 'john gary black'

is it something you can offer to try out and see if i can combine that way???
is it possible??

Regrads
T

[_RL_Ian]

I'm not sure if I understand you 100% correctly, but I wrote a simple example to help you understand the logic behind the process. Hopefully this will help.

<?php
$sql = "SELECT name FROM users";
$query = mysql_query($sql);

$string = "";

while ($row = mysql_fetch_array($query))
{
	$string .= $row['name'] . " ";
}

$sql = "UPDATE users2 SET combined_name = '" . htmlspecialchars($string) . "'";
mysql_query($sql);
?>