mysql matching? Answered
i don't really know how to phrase the question.
i'm making a Lotto game in PHP.
i have numbers 1 - 100 grouped in lots of 10 (ie. 5-15-25-35-45-55-65-75-85-95)
and i want to match them against the "house" numbers (ie. 7-15-22-35-49-55-65-75-85-99) then count how many matches in each group and put that into a column (matches)
"USER" 5-15-25-35-45-55-65-75-85-95 vs "HOUSE" 7-15-22-35-49-55-65-75-85-99 = 6 matches.
then i can count how many matches to determine "payout"
i can do this in excel easily.
SQL is harder to do.