multiple rows => 1row???

[ktsirig]

Hi all and Merry Christmas!

I wanted to ask how would I deal with the following problem:

Say I have a table [TABLE1]:
customerid name
1 nick
2 george
3 harry

and a [TABLE2]:
number car
1 Lotus
2 BMW
2 FERRARI
2 LADA
3 Lamporgini

If I want to see george's car, I would write: SELECT car from TABLE2 where number ='2';
and I would get :
BWM
FERRARI
LADA

The thing is that I don't want to get 3 lines, but just one, where each record will be separated e.g. by TAB.
But with mysql_fetch_array I will get 3 lines. I must somehow "check" for each person if he has more than one cars,
and show them in one row, not in multiple rows.

I am stuck!

[grahame]

The easiest way would be to write a loop to fetch back the three rows, and join together the results you get back with a .= operator ... something like ...

$rs = mysql_query("Select ..... ");
$result = "";
while ($row = mysql_fetch_assoc($rs)) {
$result .= $row[car] . "\t";
}