Put all results with same id in one field

[necken18]

Hello.

 

I've got two tables one that contains general information and one that contains links.

 

example:

 

Table: general

id,

name,

date

 

Table: links

id,

objekt_id,

link,

title

 

i wan't to loop out these tables together and put all links with the same objekt_id in one field-array. (links.objekt_id matches general.id).

SELECT g.name, g.date, link.link
FROM general g
INNER JOIN link links ON link.objekt_id = g.id
WHERE g.id = 10

 

There is multiplie links on every objekt_id. How can i put all of them in one field?

 

[Muddy_Funster]

read up on SELECT CONCAT() - that should get you what you need.

[fenway]

Also, PHP will do this much better.