I am trying to figure out the logic / mysql query I need to figure out "related suggestions"
So for example I have these illustrators http://www.illustrationmundo.com/illustrators.php
and if you like illustrator A you will probably like illustrator B,D,Z based on a table that contains people's favorite illustrators
the illustrator favorite table looks like this
illustrator_favorites
user_id=the user who is favoriting the illustrator
illustrator_id=the illustrator that is being favorited
So I assume I need to figure out people that like illustrator 12547 usually also likes illustrators 124,125478 and 15429
I have no idea how to do this .. any help is greatly appreciated