Hi,
Thanks for all the good replies! Especially the example, which I have been using to alter my code.
As for how this script exits, below is the output from the script:
CREATE NEW SHIAI
Start main block
parameters: shiai_name closedate eventdate entry_fee first_prize secon
+d_prize third_prize fourth_prize fifth_prize desc user_id submit butt
+on
Start of collect_shiai_data
Shiai_data array = Lance BLANK_for_now test14 m ladder m BLANK blank b
+lank 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 bla
+nk 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 W
+ed 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: Unk
+nown column constraint: 'position'! DBD::AnyData::db do failed: SQL E
+RROR: 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 fi
+led 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 jus
+t 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_la
+st_fight
Kia Kaha, Kia Toa, Kia Manawanui!
Be Strong, Be Brave, Be perservering!