Jump to content


Photo

mysql and arrays


  • Please log in to reply
4 replies to this topic

#1 blev

blev
  • Members
  • PipPip
  • Member
  • 13 posts

Posted 18 April 2006 - 10:22 AM

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 (jazz, classical, punk)
club 2 array has (pop, disco)

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

#2 Barand

Barand
  • Moderators
  • Sen . ( ile || sei )
  • 18,017 posts

Posted 18 April 2006 - 10:45 AM

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]

If you are still using mysql_ functions, STOP! Use mysqli_ or PDO. The longer you leave it the more you will have to rewrite.

Donations gratefully received






moon.png

|baaGrid| easy data tables - and more
|baaChart| easy line, column and pie charts

#3 blev

blev
  • Members
  • PipPip
  • Member
  • 13 posts

Posted 18 April 2006 - 11:32 AM

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

#4 Barand

Barand
  • Moderators
  • Sen . ( ile || sei )
  • 18,017 posts

Posted 23 April 2006 - 07:18 AM

Not being telepathic, I do not know where your data comes from.
If you are still using mysql_ functions, STOP! Use mysqli_ or PDO. The longer you leave it the more you will have to rewrite.

Donations gratefully received






moon.png

|baaGrid| easy data tables - and more
|baaChart| easy line, column and pie charts

#5 blev

blev
  • Members
  • PipPip
  • Member
  • 13 posts

Posted 23 April 2006 - 08:00 PM

all sorted now. :-)




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users