sql problem return a grouped values and a array to them

im rewriting a snippet and need to know how to do a sql querry giving two kind of results one is a grouped array of field 1 and the other is a array of the values in the field2 who has the same field1
for example
field1 values = 1,1,3,2,2
return = 1,3,2
field2 values = home,house,food,tennis,golf
return +-
array(home,house)
array(food)
array(tennis,golf)
thanks

Interesting. Is field 1 the category? Do you have another table of catagories? Something like this?

Table 1 (categories)
1 | where you live
2 | what you eat
3 | what you do

yes is for a update of a flex search form by category based in a template variable whithout harcoding the core

Then your database is structrued wrong.

http://dev.mysql.com/tech-resources/articles/intro-to-normalization.html

You need three tables, one for categories, one for items, and one to match categories to item.

table categories_items (two fields)

catID | itemID

for one thing, what if you want an item to be in more than one category? For another, you never repeat data in a table if you can at all help it (such as category id, it’s repeated for every item with that category) because it messes with the indexing.

Then you just use joins.

http://www.keithjbrown.co.uk/vworks/mysql/mysql_p5.shtml
http://hackmysql.com/case4

There are those here better at that than I am, I have to really focus down hard and spend hours figuring out the joins, but it’s really not that hard once you get the "hang" of it. I’m numerically dyslexic; I see numbers reversed, still after over four years can’t remember my phone number, and have trouble with spatial patterns (I’ve never parallel parked in my life, and can’t for the life of me solve those stupid little puzzles with the randomized squares you have to move around into their proper places.) So I figure that if I can do it with some hard work, it shouldn’t be so difficult for anybody else to learn.

thanks very much i investigate in
hi

Heh. Didn’t mean to sound so hard! But databases is one thing my second husband (the Cuban) was really really good at. He brought me kicking and screaming (figuratively!) from VB and Access to dBase, FoxPro, and then Oracle’s version of SQL; this was over 10 years ago. So I had the principles seriously beaten into me, no physical beating, but a great deal of arm waving and yelling in Spanish!

im waiting to have a little time to go into joins and end my snippet
i realy are spanish and know very little english (for years only in design forums)
when speack about computers i could imagine the words are telling but i lost a lot if is another conversation, but thanks and best regards to your wife.

thanks for the help now i end my search snippet (again a search) i post in another post,
finaly i make whith a querry to two tables and is ok for include a template variable filtering the results
hi