|
|
Posted by Rik on 03/01/07 23:30
Pankaj <panahuja@gmail.com> wrote:
> My sql query is giving me multiple records - producers, masters and
> models. I want to display all models belonging to a particular
> producer in a table column seperated by comma. However, I am unable to=
> do so. All my records get displayed in a seperate row. How can I get
> this done.
>
> eg.
>
> Table Producers
> producer_id producer_name
> Table Models
> model_id producer_id model_name
> I want results to be in the format
>
> Producer Name Model Name
> A ABC, DEF, QWE
> B ASD, ZXC
No PHP question, but just for the heck of it, something like this will =
work in MySQL (untested):
SELECT
p.`producer_name` as 'name',
GROUP_CONCAT(m.`model_name` SEPARATOR ', ') as 'models'
FROM `Producers` p
LEFT JOIN `Models` m
ON m.`producer_id` =3D p.`producer_id`
GROUP BY `producer_name`
-- =
Rik Wasmus
Navigation:
[Reply to this message]
|