CREATE NEW SHIAI

Start main block

parameters: shiai_name closedate eventdate entry_fee first_prize second_prize third_prize fourth_prize fifth_prize desc user_id submit button

Start of collect_shiai_data

Shiai_data array = Lance BLANK_for_now test14 m ladder m BLANK blank blank BLANK m blank m m m m m m

Start of validate_shiai_data

validated data = Lance BLANK_for_now test14 m ladder m BLANK blank blank BLANK m blank m m m m m m

Start of generate_initial_values

Internal dta now equals = Lance Lancetest14 test14 m ladder m for now just an abitrary data filed till I pass the users name OK! NO 0 0 m Wed Jan 28 21:01:29 2004 m m m m m m

Validated data + initial values = Lance Lancetest14 test14 m ladder m for now just an abitrary data filed till I pass the users name OK! NO 0 0 m Wed Jan 28 21:01:29 2004 m m m m m m

END of generate_initial_values

Start of add_shiai_to_db subroutine
SELECT * FROM shiai_db WHERE shiai_id = ? [Lancetest14] SQL ERROR: Unknown column constraint: 'position'! DBD::AnyData::db do failed: SQL ERROR: Unknown column constraint: 'position'! 

about to insert the new record
INSERT INTO shiai_db VALUES ( ?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,? ) [Lance Lancetest14 test14 m ladder m for now just an abitrary data filed till I pass the users name OK! NO 0 0 m Wed Jan 28 21:01:29 2004 m m m m m m] 

Shiai Created

Data added to the DB = Lance Lancetest14 test14 m ladder m for now just an abitrary data filed till I pass the users name OK! NO 0 0 m Wed Jan 28 21:01:29 2004 m m m m m m

END of add_shiai_to_db subroutine

Start of create shiai db files

Start of createladder_data

table fields = player_name ID position fights wins joined_date date_last_fight