dk01 — Fri, 30 Dec 2005 13:51:59 +0000

So you are saying instead of seeing:
BWM
FERRARI
LADA

You want to see:
BMW FERRARI LADA

If this is all you want then just take out the in your echo statement and add a space in its place.

Should be fairly simple.

chrishirst — Fri, 30 Dec 2005 13:33:09 +0000

it's a display problem not a SQL problem if there is three matching rows you will get three returned using LIMIT=1 will only return the first record from the set which maybe BMW or LADA depending on what order you retrieve the records.

get the result, if there is more than one record display accordingly

Renegade — Fri, 30 Dec 2005 12:41:49 +0000

Try this:

SELECT car FROM table2 WHERE number='2' LIMIT='1'