Smudly Posted April 29, 2011 Share Posted April 29, 2011 I'm working on a Lottery system. The user uses their Drawing Tickets for a chance to win. The way I currently have this setup, is the user can type in 8 Drawing tickets for example, and this will be placed into a row. So it would be like: id -- userid -- username -- drawing_ticket -- status -- date 1 -- 12 -- PapaGeorgio -- 8 -- active -- 2011-04-28 So this row will have 8 chances to be selected as the winner. I thought of just making 1 row for each drawing ticket entered, but this would be a lot of querying. What method may I use to do this? $drawquery = mysql_query("SELECT * FROM weeklydrawing WHERE `drawing_ticket`>=1 AND status='active' ORDER BY rand() LIMIT 50"); Link to comment https://forums.phpfreaks.com/topic/235115-lottery-system/ Share on other sites More sharing options...
fugix Posted April 29, 2011 Share Posted April 29, 2011 just a quick tip.. the `` are acceptable but are not needed Link to comment https://forums.phpfreaks.com/topic/235115-lottery-system/#findComment-1208440 Share on other sites More sharing options...
fenway Posted May 1, 2011 Share Posted May 1, 2011 One row per entity is absolutely required. Link to comment https://forums.phpfreaks.com/topic/235115-lottery-system/#findComment-1209139 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.