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

[download]
Kia Kaha, Kia Toa, Kia Manawanui!
Be Strong, Be Brave, Be perservering!

In reply to Re: Re: DBD::ANYDATA create table help please. by lwicks
in thread DBD::ANYDATA create table by lwicks

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.