mysql and arrays

[blev]

first off, hello. First post on this board.

I'm trying compare a users music style with the music styles for various club nights and find out which is better suited.

How do add the various music styles into an arrays so i can compare these results to that array i created with the users music preference

e.g. The users array will contain (jazz, pop, disco)

and club 1 array has ([i]jazz[/i], classical, punk)
club 2 array has ([i]pop[/i], [i]disco[/i])

club 1 would then score 1 because it matched 1 style from the users first array and be added to another new array
club 2 would score 2 and be added ahead club 1 in the new array.

hope someone can help.thanks

[Barand]

See

[a href=\"http://www.php.net/array_intersect\" target=\"_blank\"]http://www.php.net/array_intersect[/a]

and

[a href=\"http://www.php.net/count\" target=\"_blank\"]http://www.php.net/count[/a]

[blev]

Thats great, thanks.

How do I loop through the results of the clubmusic styles storing that in an array for each club????

this is the part that i'm struggling with most. any help appriciated

[Barand]

Not being telepathic, I do not know where your data comes from.

[blev]

all sorted now. :-)