Select one row from MySQL table

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

[Niheel]

Merry Christmas and Happy New Years! Only one day away from 2006.

Regrading your problem:

You can limit the results by using LIMIT.

In your case the example would look like:
SELECT car FROM table2 WHERE number='3' LIMIT 1

You can change that 1 to what ever number of results you like. Hope that helped you out. If not reply back.

[SQL Maestro]

At the moment i can't to check up - what if request is will be like this?

SELECT car FROM table2 WHERE number = '2' GROUP by number

[Niheel]

KStirig, did the solution help you answer the question? Are you trying to also group the results like:

lotus
bmw, ferrari, lada
lamborghini