[Resolved] data from 1 column but 2 rows in 1 result

[tdomega]

Hi,

I have a table that stores contacts as senders and receivers
(looks like table.senderid=3; table.receiverid=5)

Now I have an additional table with the names of those ids in it

My question is, can i extract the names from both in one result?

so i can do something like this:
$result=mysql_query(?);
$vars=mysql_fetch_assoc($result);
echo $vars["sendername"]."-".$vars["receivername"];

I cant figure out the query, any ideas?

[Grisu]

I name the table contacts and the linked table names. To make the left join possible we need aliases. Then the query would be:

SELECT alias1.name AS sendername, alias2.name AS receivername FROM ((tables LEFT JOIN names AS alias1 ON tables.senderid = alias1.id) LEFT JOIN namea AS alias2 ON tables.receiverid = alias2.id)

As you can imagine this connects all records in contacts with WHERE you can select the records you want to see.

Should work this way.

Grisu

[TTT]

SELECT DISTINCT(alias1.name) AS sendername, alias2.name AS receivername FROM tables t LEFT JOIN names AS alias1 ON t.senderid = alias1.id LEFT JOIN namea AS alias2 ON t.receiverid = alias2.id

[tdomega]

Thanks, works perfect now 🙂