Thread:Sylvandyr/@comment-5619126-20121014124324/@comment-5619126-20121028144956

I need both ways :)

getting parents is required to show your breeding options to breed a certain dragon based upon the dragons you already have

getting offspring is required to check if submitted breeding values are correct

Yeah, I forgot that one of the two can be a diamond to get a pure one. Added that now. Cut the diamond section on its own and integrated it with the single color one.

--> SELECT * FROM dragons WHERE (color1 = ? OR color1 = "Diamond") AND color2 IS NULL

And then from the result made a cartesion product.