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. Link to comment https://forums.phpfreaks.com/topic/81155-sql-help/ 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. Link to comment https://forums.phpfreaks.com/topic/81155-sql-help/#findComment-411959 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 Link to comment https://forums.phpfreaks.com/topic/81155-sql-help/#findComment-418316 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. Link to comment https://forums.phpfreaks.com/topic/81155-sql-help/#findComment-418949 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.