karldesign Posted December 11, 2007 Share Posted December 11, 2007 I have 2 database tables for a project: tbl_results and tbl_numbers In the numbers table, a user picks six numbers and in the results table, there are 7 numbers. Based on the UK Lotto rules, I want to shorten my SQL statement to perform winning checks of 3, 4, 5, 5+ bonus, 6 numbers... At the moment, I have done a check for 3, but the SQL statement is full of ORs and ANDs... too many I think... Any help would be great. Quote Link to comment Share on other sites More sharing options...
fenway Posted December 11, 2007 Share Posted December 11, 2007 If you had each user's pick in a separate row, this would be super easy. Quote Link to comment Share on other sites More sharing options...
karldesign Posted December 19, 2007 Author Share Posted December 19, 2007 i do: user_id | num_1 | num_2 etc Quote Link to comment Share on other sites More sharing options...
fenway Posted December 19, 2007 Share Posted December 19, 2007 i do: user_id | num_1 | num_2 etc Yes, I see that... that's why you're having trouble. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.