multiple rows => 1 row???

[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!

[thephpguy]

Use this:

$queryResult = "SELECT car from TABLE2 where number ='2'";
$cars = '';
for ($i=0; $i<mysql_num_rows($queryResult); ++$i) {
  $row = mysql_fetch_row($queryResult);
  $cars .= $row[0] . "\t";
}

[tommynanda]

Also, add a trim function after 'for' loop to avoid extra tab after the end