When the numbers are drawn, if any members ticket numbers matches ANY and in Any Order of admin prize numbers they win lets say prize one,or two or three, then what ever the amount of the credits they win, then the members credits_num get updated with that amount.
Table one
CREATE TABLE admin_prize (
id int(11) NOT NULL auto_increment,
drawdate date default NULL,
ticketcost float default NULL,
number1 int(11) default NULL,
number2 int(11) default NULL,
number3 int(11) default NULL,
number4 int(11) default NULL,
number5 int(11) default NULL,
prize1 float default NULL,
prize2 float default NULL,
prize3 float default NULL,
prize4 float default NULL,
PRIMARY KEY (id)
) TYPE=MyISAM;
Table Two
CREATE TABLE tickets (
id int(11) NOT NULL auto_increment,
userid int(11) default NULL,
number1 int(11) default NULL,
number2 int(11) default NULL,
number3 int(11) default NULL,
number4 int(11) default NULL,
number5 int(11) default NULL,
status int(11) default NULL,
ticketdate date default NULL,
drawdate date default NULL,
PRIMARY KEY (id)
) TYPE=MyISAM;
And members table
create table members(
id int(11) not null auto_increment,
login varchar(255),
pswd varchar(255),
fname varchar(255),
lname varchar(255),
email varchar(255),
city varchar(255),
state varchar(255),
country varchar(255),
zip varchar(255),
phone varchar(255),
fax varchar(255),
prcode varchar(255),
status integer,
rdate integer,
website varchar(255) default NULL,
birthday date NOT NULL default '0000-00-00',
primary key(id)
);
And here is the table that stores the members credits
create table members_credits(
id int(11) not null auto_increment,
user_id integer,
credits_num float(14,3),
primary key(id)
);
