2. PHPRunner General questions
  3. Looking for ideas on Lottery Database
This topic is locked

Looking for ideas on Lottery Database

 		1/30/2010 3:50:35 PM
PHPRunner General questions
S
 swanside author

Hello.

I want to make an online lottery checker, It would consists of a number of usernames, each user would have 6 numbers. Every week, my wife would check the lotto results and enter them in a page. if a user has a number, the cell which holds that number would go green.

Any ideas on how to go about this project would be great. It will be on a MySQL database.

Cheers

Paul.
D
 		Dale 1/30/2010

Three tables
Users (ticket holders) Login username and password info, user id#, Name or Alias, email address.

Results (Data entry of winning numbers) Lotto date and id, 6 number fields ( maybe fields for $$ amount for winning numbers)

Tickets (Data entry of user ticket numbers) User id, lotto date and id, 6 number fields.
User logs in automatically go to his tickets list, (Security built around users, see their own data etc.)

Use before record processed event to check ticket numbers against the correct winning numbers and highlight matched table cells in green.
A master table link on the Results table to the Tickets table, list tickets entered for the particular lottery.
Should be a quick project to complete. Lots of other features, auto emailing winners, whose won, when and how much, etc etc. and advertising module.
S
 		swanside author 1/31/2010



Three tables
Users (ticket holders) Login username and password info, user id#, Name or Alias, email address.

Results (Data entry of winning numbers) Lotto date and id, 6 number fields ( maybe fields for $$ amount for winning numbers)

Tickets (Data entry of user ticket numbers) User id, lotto date and id, 6 number fields.
User logs in automatically go to his tickets list, (Security built around users, see their own data etc.)

Use before record processed event to check ticket numbers against the correct winning numbers and highlight matched table cells in green.
A master table link on the Results table to the Tickets table, list tickets entered for the particular lottery.
Should be a quick project to complete. Lots of other features, auto emailing winners, whose won, when and how much, etc etc. and advertising module.


Thanks for the info, I will start on that this week, and up it to a demo account to see how it turns out.

Thanks

paul.
T
 		Tokyoj 2/2/2010

Just an idea from a newbie but your idea could also be adopted to include in a site to offer a 'random winner' from Register Users....wouldn't it? For example, 1x per month a registered user wins something (pen site, clean socks, etc...)...door prize type of incentive.



Thanks for the info, I will start on that this week, and up it to a demo account to see how it turns out.

Thanks

paul.
S
 		swanside author 2/2/2010

I might need to re-think.
The way it works at the moment, My wifes work, they all pick six number from 1 - 49. Each pays £1.00 per week into a pot, and every Saturday night they tick off there numbers on there lines according to what numbers are called out on the lottery. The first to complete there line wins, so its like a Bingo game, but using the lottery numbers.
For example.

User1 might have 1,22,14,24,27,39

User2 might have 3,12,14,24,29,41
On week one the lottery nu,bers might be 1,11,15,28,42,49. In this case, user1 would wipe out number 1 and would only need 5 numbers to win, where user2 would not wipe out any numbers.

The following week, the lottery numbers might be 2,3,14,24,28,43

Now user 1 would wipe out another number, now only needing 4 numbers to win, but user2 would wipe out 3 numbers and only need three numbers to win. This goes on every week until the first person to get all the numbers wipped out wins.