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"); Quote Link to comment 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 Quote Link to comment Share on other sites More sharing options...
fenway Posted May 1, 2011 Share Posted May 1, 2011 One row per entity is absolutely required. 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.