[SOLVED] Merging data

[brob]

Hi can someone help.

 

I need to pull this info from a database and merge it based on the secondary_id can anyone suggest how?

 

id  secondary_id  name  desc

-------------------------------

1  27                  toy    sega

2  27                  toy    nintendo

3  32                  cd      coldplay

4  32                  cd      nelly

[hvle]

merge with what brob?

 

[brob]

merge with one another.

 

So both sets of seondary_id = 27 are in one statement and both sets of secondary_id = 32 are in another statement.

 

Sorry for being a vague.

[hvle]

select * from table1 join table2 on table1.secondary_id=table2.secondary_id;

[brob]

they are both in the same table please do you know of another way?

[hvle]

sorry for my misreading.

 

use grouping:

 

select * from table group by secondary_id order by secondary_id;

[brob]

hi thanks for this but grouping would remove one of the entries and not maintain the both sets of results i.e. 27 toy toy sega nintendo

 

this is what I want to achieve and not lose any of the data

[hvle]

why don't you give visual example of what the results should look like?

[effigy]

SELECT name, GROUP_CONCAT(`desc` SEPARATOR ', ') AS items FROM table GROUP BY secondary_id;

yields:

+------+-----------------+

| name | items          |

+------+-----------------+

| toy  | sega, nintendo  |

| cd  | coldplay, nelly |

+------+-----------------+

 

[brob]

i would like to have pulled from the database

 

$id = 27

$type = toy

$brand = sega, nintendo

 

$id = 32

$type = cd

$brand = coldplay, nelly

[brob]

effigy thank you so mutch this is exactly what I needed and has worked a treat.

 

Great post

[fenway]

Just remember there there's a max_length to group_concat.