Forums

Form doesn't submit all info

comtech 03 Apr, 2009
I've created a form for a UFO Report Database and while testing it I found it does not submit all submitted data.
The Date comes through just fine but none of the other information comes through.

Does anyone have an idea on how to fix this?

<TABLE width=600 border=0 height="327">
        <TBODY>
        <TR>

          <TD vAlign=middle align=right width=170 height="25"><FONT face=Arial 
            size=2><B>Event Date :</B></FONT></TD>
          <TD vAlign=middle width=416 align="left" height="25"><FONT face=Arial size=2>
          	<INPUT maxLength=10 size=8 name="100 Date" onkeypress="return noenter()" onblur="validate_date(this,'Event Date')">  <FONT color=#ff0000><<</FONT> 
            </FONT><FONT face=Arial color=#ff0000 size=1><B>Use MM/DD/YY format</B></FONT><FONT face=Arial 
            size=2>            </FONT></TD></TR>
        <TR>
          <TD align=right width=170 height="35"></TD>
          <TD width=416 height="35"><FONT face=Arial 
            size=2> If you do not know the exact date, enter your best 
            guess <BR> and check this box  >>  <INPUT type=checkbox 
            value=Yes name="105 Approximate"> </FONT></TD></TR>


        <TR>
          <TD align=right width=170 valign="middle" height="1"><FONT face=Arial size=2><B>Event Time 
            :</B></FONT></TD>
          <TD width=416 height="1"><FONT face=Arial size=2><INPUT maxLength=8 size=8 
            name="110 Time" onkeypress="return noenter()" onblur="validate_time(this)">  </FONT><font color="#FF0000" face="Arial" size="1"><b><<
            Use HH:MM 24 
            hour format.  Examples:</b></font></TD></TR>
        <TR>
          <TD align=right width=170 height="25"></TD>

          <TD width=416 height="25"><font color="#FF0000" face="Arial" size="1"><b>                                 
            0:00 = Midnight<br>
                                             
            1:00 = 1:00 AM<br>
                                             
            12:00 = Noon<br>
                                             

            13:00 = 1 PM  <br>
                                             
            23:00 = 11:00 PM </b></font></TD></TR>
        <TR>
          <TD align=right width=170 height="25"><FONT face=Arial size=2><B>Event 
            Duration :</B></FONT></TD>
          <TD width=416 height="25"><FONT face=Arial size=2><INPUT size=12 
            name="120 Duration" onkeypress="return noenter()" > </FONT></TD></TR>

        <TR>
          <TD align=right width=170 height="25"><FONT face=Arial size=2><B>City 
            :</B></FONT></TD>
          <TD width=416 height="25"><FONT face=Arial size=2><INPUT size=26 
            name="130 Sighting City" onkeypress="return noenter()" > </FONT></TD></TR>
        <TR>
          <TD align=right width=170 height="25"><FONT face=Arial size=2><B>State / 
            Province :</B></FONT></TD>
          <TD width=416 height="25"><SELECT size=1 name="140 Sighting State" cols="20"> 
              <OPTION selected>.<OPTION value=al>Alabama<OPTION 
              value=ak>Alaska<OPTION value=ab>Alberta<OPTION 
              value=az>Arizona<OPTION value=ar>Arkansas<OPTION value=bc>British 
              Columbia<OPTION value=ca>California<OPTION 
              value=co>Colorado<OPTION value=ct>Connecticut<OPTION 
              value=dc>D.C.<OPTION value=de>Delaware<OPTION 
              value=fl>Florida<OPTION value=ga>Georgia<OPTION 
              value=hi>Hawaii<OPTION value=id>Idaho<OPTION 
              value=il>Illinois<OPTION value=in>Indiana<OPTION 
              value=ia>Iowa<OPTION value=ks>Kansas<OPTION 
              value=ky>Kentucky<OPTION value=la>Louisiana<OPTION 
              value=me>Maine<OPTION value=mb>Manitoba<OPTION 
              value=md>Maryland<OPTION value=ma>Massachusetts<OPTION 
              value=mi>Michigan<OPTION value=mn>Minnesota<OPTION 
              value=ms>Mississippi<OPTION value=mo>Missouri<OPTION 
              value=mt>Montana<OPTION value=ne>Nebraska<OPTION 
              value=nv>Nevada<OPTION value=nb>New Brunswick<OPTION value=nh>New 
              Hampshire<OPTION value=nj>New Jersey<OPTION value=nm>New 
              Mexico<OPTION value=ny>New York<OPTION 
              value=nf>Newfoundland<OPTION value=nc>North Carolina<OPTION 
              value=nd>North Dakota<OPTION value=nt>Northwest Terr.<OPTION 
              value=ns>Nova Scotia<OPTION value=oh>Ohio<OPTION 
              value=ok>Oklahoma<OPTION value=on>Ontario<OPTION 
              value=or>Oregon<OPTION value=pa>Pennsylvania<OPTION 
              value=pe>Prince Edward Isl.<OPTION value=qc>Quebec<OPTION 
              value=ri>Rhode Island<OPTION value=sk>Saskatchewan<OPTION 
              value=sc>South Carolina<OPTION value=sd>South Dakota<OPTION 
              value=tn>Tennessee<OPTION value=tx>Texas<OPTION 
              value=ut>Utah<OPTION value=vt>Vermont<OPTION 
              value=va>Virginia<OPTION value=wa>Washington<OPTION value=wv>West 
              Virginia<OPTION value=wi>Wisconsin<OPTION value=wy>Wyoming<OPTION 
              value=yt>Yukon</OPTION></SELECT></TD></TR>

        <TR>
          <TD align=right width=170 height="25"><FONT face=Arial size=2><B>Zip 
            Code :</B></FONT></TD>
          <TD width=416 height="25"><FONT face=Arial size=2><INPUT size=12 
            onkeypress="return noenter()" name="150 Sighting Zip"> </FONT></TD></TR>
        <TR>
          <TD align=right width=170 height="25"><FONT face=Arial size=2><B>Foreign 
            Country :</B></FONT></TD>
          <TD width=416 height="25"><FONT face=Arial size=2><INPUT size=26 
            name="165 Sighting Country" onkeypress="return noenter()" > </FONT></TD></TR>

        <TR>
          <TD align=right width=170 height="25"><FONT face=Arial size=2><B>County </B> :</FONT></TD>
          <TD width=416 height="25"><FONT face=Arial size=2><INPUT size=26 
            name="160 Sighting County" onkeypress="return noenter()">   </FONT><font color="#ff0000" face="Arial" size="1"><b><<
            enter if inside USA only</b></font></TD></TR>
        <TR>
          <TD align=right width=170 height="25"><FONT face=Arial size=2><B>Number of 
            witnesses :</B></FONT></TD>

          <TD width=416 height="25"><FONT face=Arial size=2><INPUT size=8 
            name="170 Witnesses" onkeypress="return noenter()"> </FONT></TD></TR>
        <TR>
          <TD align=right width=170 height="25"><FONT face=Arial size=2><B>Shape of 
            Craft :</B></FONT></TD>
          <TD width=416 height="25"><FONT face=Arial size=2><SELECT 
              name="172 Shape"><OPTION value="" selected><OPTION 
              value=Changing>Changed Shape <OPTION 
              value=Chevron>Chevron <OPTION value=Cigar>Cigar <OPTION 
              value=Circle>Circle <OPTION value=Cone>Cone <OPTION 
              value=Cross>Cross <OPTION 
              value=Cylinder>Cylinder <OPTION 
              value=Diamond>Diamond <OPTION value=Disk>Disk or 
              Saucer <OPTION value=Egg>Egg <OPTION 
              value=Fireball>Fireball <OPTION 
              value=Flash>Flash <OPTION 
              value=Formation>Formation <OPTION 
              value=Light>Light <OPTION value=Oval>Oval <OPTION 
              value=Rectangle>Rectangle <OPTION 
              value=Sphere>Sphere <OPTION 
              value=Teardrop>Teardrop <OPTION 
              value=Triangle>Triangle <OPTION 
              value=Other>Other <OPTION 
            value=Unknown>Unknown </OPTION></SELECT> </FONT></TD></TR>

        <TR>
          <TD align=right width=170 height="25"><FONT face=Arial size=2><B>Number of craft 
            seen :</B></FONT></TD>
          <TD width=416 height="25"><FONT face=Arial size=2><INPUT size=8 
            name="168 Number of Craft" onkeypress="return noenter()" > </FONT></TD></TR></TBODY></TABLE>
Max_admin 03 Apr, 2009
Hi comtech,

some of your fields names have spaces or - or start with a number 0-9 ? if so (and I see that) then you should fix this (because its a wrong HTML and makes problems with the table) then recreate a new table and connect to the new table and ignore the old one! only then it will work!

Regards,
Max
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
This topic is locked and no more replies can be posted.