Topic: Need help with arrays, select multiple rows when selectorvalue match

[vaupell]

database looks like this

id|columa|user|columc
---------------------------
1|dataA|user|selectorid1
2|dataB|user|selectorid2
3|dataC|user|selectorid3
4|dataA|user1|selectorid1
5|dataB|user1|selectorid2
6|dataC|user1|selectorid3
7|dataA|user2|selectorid1
8|dataB|user2|selectorid2
9|dataC|user2|selectorid3
----------------------------

What i need is

user - dataB
user1 - dataB
user2 - dataB

I dont know the values of the usernames/id's and i donot know the dataB contents
i DO know selectorid2

so i was thinking something like this

$getdataB = SELECT DESTINCT dataB FROM mytable WHERE selectorid2 ;

but how do i now show/work with the data from dataB
i was thinking something like

foreach $getdataB
{
echo $getdataB;
}

which ofcourse didnt work..

any help on this matter would be appriciated..  thank you.

[fenway]

I don't follow.

[vaupell]

I dropped the issue, the database struckture was just to crazy.

It allowed a admin of the cms to create costum items, placed between fixed items in a form for the users.
i changed it so the fixed items got structured in its own table and was easy to select,
while the costum now is selected by the selectorid.. 

solved, but not like original intended..