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
[download]

In my situation I want to create a table called userTable.ldr (or perhaps better would be userTable_ldr ?)
But I want the table created in the data/shiai_data/ directory.

Thoughts?

Lance.