My select box is not adding data to MySQL?

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
User avatar
cap2cap10
Forum Contributor
Posts: 158
Joined: Mon Apr 14, 2008 11:06 pm

My select box is not adding data to MySQL?

Post by cap2cap10 »

:banghead: My select box in my php form is not adding data to mysql table.
Here is the code:

Code: Select all

<SELECT name=Country  tabindex=14 >
<OPTION value=USA>United States</OPTION>
<OPTION value=CAN>Canada</OPTION>
<OPTION value=AFG>Afghanistan</OPTION>
<OPTION value=ALB>Albania</OPTION>
<OPTION value=DZA>Algeria</OPTION>
<OPTION value=ASM>American Samoa</OPTION>
<OPTION value=AND>Andorra</OPTION>
<OPTION value=AGO>Angola</OPTION>
<OPTION value=AIA>Anguilla</OPTION>
<OPTION value=ATA>Antarctica</OPTION>
<OPTION value=ATG>Antigua And Barbuda</OPTION>
<OPTION value=ARG>Argentina</OPTION>
<OPTION value=ARM>Armenia</OPTION>
<OPTION value=ABW>Aruba</OPTION>
<OPTION value=AUS>Australia</OPTION>
<OPTION value=AUT>Austria</OPTION>
<OPTION value=AZE>Azerbaijan</OPTION>
<OPTION value=BHS>Bahamas</OPTION>
<OPTION value=BHR>Bahrain</OPTION>
<OPTION value=BGD>Bangladesh</OPTION>
<OPTION value=BRB>Barbados</OPTION>
<OPTION value=BLR>Belarus</OPTION>
<OPTION value=BEL>Belgium</OPTION>
<OPTION value=BLZ>Belize</OPTION>
<OPTION value=BEN>Benin</OPTION>
<OPTION value=BMU>Bermuda</OPTION>
<OPTION value=BTN>Bhutan</OPTION>
<OPTION value=BOL>Bolivia</OPTION>
<OPTION value=BIH>Bosnia And Herzegovina</OPTION>
<OPTION value=BWA>Botswana</OPTION>
<OPTION value=BVT>Bouvet Island</OPTION>
<OPTION value=BRA>Brazil</OPTION>
<OPTION value=IOT>British Indian Ocean Territory</OPTION>
<OPTION value=BRN>Brunei Darussalam</OPTION>
<OPTION value=BGR>Bulgaria</OPTION>
<OPTION value=BFA>Burkina Faso</OPTION>
<OPTION value=BDI>Burundi</OPTION>
<OPTION value=KHM>Cambodia</OPTION>
<OPTION value=CMR>Cameroon</OPTION>
<OPTION value=CPV>Cape Verde</OPTION>
<OPTION value=CYM>Cayman Islands</OPTION>
<OPTION value=CAF>Central African Republic</OPTION>
<OPTION value=TCD>Chad</OPTION>
<OPTION value=CHL>Chile</OPTION>
<OPTION value=CHN>China</OPTION>
<OPTION value=CXR>Christmas Island</OPTION>
<OPTION value=CCK>Cocos (Keeling)Islands</OPTION>
<OPTION value=COL>Colombia</OPTION>
<OPTION value=COM>Comoros</OPTION>
<OPTION value=COG>Congo</OPTION>
<OPTION value=COK>Cook Islands</OPTION>
<OPTION value=CRI>Costa Rica</OPTION>
<OPTION value=CIV>Cote Divoire</OPTION>
<OPTION value=HRV>Croatia (Local Name: Hrvatska)</OPTION>
<OPTION value=CUB>Cuba</OPTION>
<OPTION value=CYP>Cyprus</OPTION>
<OPTION value=CZE>Czech  Republic</OPTION>
<OPTION value=ZAR>Democratic Republic of the Congo</OPTION>
<OPTION value=DNK>Denmark</OPTION>
<OPTION value=DJI>Djibouti</OPTION>
<OPTION value=DMA>Dominica</OPTION>
<OPTION value=DOM>Dominican Republic</OPTION>
<OPTION value=TMP>East Timor</OPTION>
<OPTION value=ECU>Ecuador</OPTION>
<OPTION value=EGY>Egypt</OPTION>
<OPTION value=SLV>El Salvador</OPTION>
<OPTION value=GNQ>Equatorial Guinea</OPTION>
<OPTION value=ERI>Eritrea</OPTION>
<OPTION value=EST>Estonia</OPTION>
<OPTION value=ETH>Ethiopia</OPTION>
<OPTION value=FLK>Falkland Islands (Malvinas)</OPTION>
<OPTION value=FRO>Faroe Islands</OPTION>
<OPTION value=FJI>Fiji</OPTION>
<OPTION value=FIN>Finland</OPTION>
<OPTION value=FRA>France</OPTION>
<OPTION value=GUF>French Guiana</OPTION>
<OPTION value=PYF>French Polynesia</OPTION>
<OPTION value=ATF>French Southern Territories</OPTION>
<OPTION value=GAB>Gabon</OPTION>
<OPTION value=GMB>Gambia</OPTION>
<OPTION value=GEO>Georgia</OPTION>
<OPTION value=DEU>Germany</OPTION>
<OPTION value=GHA>Ghana</OPTION>
<OPTION value=GIB>Gibraltar</OPTION>
<OPTION value=GRC>Greece</OPTION>
<OPTION value=GRL>Greenland</OPTION>
<OPTION value=GRD>Grenada</OPTION>
<OPTION value=GLP>Guadeloupe</OPTION>
<OPTION value=GUM>Guam</OPTION>
<OPTION value=GTM>Guatemala</OPTION>
<OPTION value=GIN>Guinea</OPTION>
<OPTION value=GNB>Guinea  Bissau</OPTION>
<OPTION value=GUY>Guyana</OPTION>
<OPTION value=HTI>Haiti</OPTION>
<OPTION value=HMB>Heard And Mc Donald Islands</OPTION>
<OPTION value=HND>Honduras</OPTION>
<OPTION value=HKG>Hong Kong</OPTION>
<OPTION value=HUN>Hungary</OPTION>
<OPTION value=ISL>Iceland</OPTION>
<OPTION value=IND>India</OPTION>
<OPTION value=IDN>Indonesia</OPTION>
<OPTION value=IRN>Iran (Islamic Republic Of)</OPTION>
<OPTION value=IRQ>Iraq</OPTION>
<OPTION value=IRL>Ireland</OPTION>
<OPTION value=ISR>Israel</OPTION>
<OPTION value=ITA>Italy</OPTION>
<OPTION value=JAM>Jamaica</OPTION>
<OPTION value=JPN>Japan</OPTION>
<OPTION value=JOR>Jordan</OPTION>
<OPTION value=KAZ>Kazakhstan</OPTION>
<OPTION value=KEN>Kenya</OPTION>
<OPTION value=KIR>Kiribati</OPTION>
<OPTION value=PRK>Korea, Democratic Peoples Republic OF</OPTION>
<OPTION value=KOR>Korea, Republic Of</OPTION>
<OPTION value=KWT>Kuwait</OPTION>
<OPTION value=KGZ>Kyrgyzstan</OPTION>
<OPTION value=LAO>Lao Peoples Democratic Republic</OPTION>
<OPTION value=LVA>Latvia</OPTION>
<OPTION value=LBN>Lebanon</OPTION>
<OPTION value=LSO>Lesotho</OPTION>
<OPTION value=LBR>Liberia</OPTION>
<OPTION value=LBY>Libyan Arab Jamahiriya</OPTION>
<OPTION value=LIE>Liechtenstein</OPTION>
<OPTION value=LTU>Lithuania</OPTION>
<OPTION value=LUX>Luxembourg</OPTION>
<OPTION value=MRC>Macau</OPTION>
<OPTION value=MKD>Macedonia</OPTION>
<OPTION value=MDG>Madagascar</OPTION>
<OPTION value=MWI>Malawi</OPTION>
<OPTION value=MYS>Malaysia</OPTION>
<OPTION value=MDV>Maldives</OPTION>
<OPTION value=MLI>Mali</OPTION>
<OPTION value=MLT>Malta</OPTION>
<OPTION value=MHL>Marshall Islands</OPTION>
<OPTION value=MTQ>Martinique</OPTION>
<OPTION value=MRT>Mauritania</OPTION>
<OPTION value=MUS>Mauritius</OPTION>
<OPTION value=MYT>Mayotte</OPTION>
<OPTION value=MEX>Mexico</OPTION>
<OPTION value=FSM>Micronesia, Federated States Of</OPTION>
<OPTION value=MDA>Moldova, Republic Of</OPTION>
<OPTION value=MCO>Monaco</OPTION>
<OPTION value=MNG>Mongolia</OPTION>
<OPTION value=MSR>Montserrat</OPTION>
<OPTION value=MAR>Morocco</OPTION>
<OPTION value=MOZ>Mozambique</OPTION>
<OPTION value=MMR>Myanmar</OPTION>
<OPTION value=NAM>Namibia</OPTION>
<OPTION value=NRU>Nauru</OPTION>
<OPTION value=NPL>Nepal</OPTION>
<OPTION value=NLD>Netherlands</OPTION>
<OPTION value=ANT>Netherlands Antilles</OPTION>
<OPTION value=NCL>New Caledonia</OPTION>
<OPTION value=NZL>New Zealand</OPTION>
<OPTION value=NIC>Nicaragua</OPTION>
<OPTION value=NER>Niger</OPTION>
<OPTION value=NGA>Nigeria</OPTION>
<OPTION value=NIU>Niue</OPTION>
<OPTION value=NFK>Norfolk Island</OPTION>
<OPTION value=MNP>Northern Mariana Islands</OPTION>
<OPTION value=NOR>Norway</OPTION>
<OPTION value=OMN>Oman</OPTION>
<OPTION value=PAK>Pakistan</OPTION>
<OPTION value=PLW>Palau</OPTION>
<OPTION value=PSE>Palestinian Territory, Occupied</OPTION>
<OPTION value=PAN>Panama</OPTION>
<OPTION value=PNG>Papua New Guinea</OPTION>
<OPTION value=PRY>Paraguay</OPTION>
<OPTION value=PER>Peru</OPTION>
<OPTION value=PHL>Philippines</OPTION>
<OPTION value=PCN>Pitcairn</OPTION>
<OPTION value=POL>Poland</OPTION>
<OPTION value=PRT>Portugal</OPTION>
<OPTION value=PRI>Puerto Rico</OPTION>
<OPTION value=QAT>Qatar</OPTION>
<OPTION value=REU>Reunion</OPTION>
<OPTION value=ROM>Romania</OPTION>
<OPTION value=RUS>Russian Federation</OPTION>
<OPTION value=RWA>Rwanda</OPTION>
<OPTION value=KNA>Saint Kitts And Nevis</OPTION>
<OPTION value=LCA>Saint Lucia</OPTION>
<OPTION value=VCT>Saint Vincent And The Grenadines</OPTION>
<OPTION value=WSM>Samoa</OPTION>
<OPTION value=SMR>San Marino</OPTION>
<OPTION value=STP>Sao Tome And Principe</OPTION>
<OPTION value=SAU>Saudi Arabia</OPTION>
<OPTION value=SEN>Senegal</OPTION>
<OPTION value=SME>Serbia and Montenegro</OPTION>
<OPTION value=SYC>Seychelles</OPTION>
<OPTION value=SLE>Sierra Leone</OPTION>
<OPTION value=SGP>Singapore</OPTION>
<OPTION value=SVK>Slovakia (Slovak Republic)</OPTION>
<OPTION value=SVN>Slovenia</OPTION>
<OPTION value=SLB>Solomon Islands</OPTION>
<OPTION value=SOM>Somalia</OPTION>
<OPTION value=ZAF>South Africa</OPTION>
<OPTION value=SGS>South Georgia</OPTION>
<OPTION value=ESP>Spain</OPTION>
<OPTION value=LKA>Sri Lanka</OPTION>
<OPTION value=SHN>St. Helena</OPTION>
<OPTION value=SPM>St. Pierre And Miquelon</OPTION>
<OPTION value=SDN>Sudan</OPTION>
<OPTION value=SUR>Suriname</OPTION>
<OPTION value=SJM>Svalbard And Jan Mayen Islands</OPTION>
<OPTION value=SWZ>Swaziland</OPTION>
<OPTION value=SWE>Sweden</OPTION>
<OPTION value=CHE>Switzerland</OPTION>
<OPTION value=SYR>Syrian Arab Republic</OPTION>
<OPTION value=TWN>Taiwan</OPTION>
<OPTION value=TJK>Tajikistan</OPTION>
<OPTION value=TZA>Tanzania, United Republic Of</OPTION>
<OPTION value=THA>Thailand</OPTION>
<OPTION value=TGO>Togo</OPTION>
<OPTION value=TKL>Tokelau</OPTION>
<OPTION value=TON>Tonga</OPTION>
<OPTION value=TTO>Trinidad And Tobago</OPTION>
<OPTION value=TUN>Tunisia</OPTION>
<OPTION value=TUR>Turkey</OPTION>
<OPTION value=TKM>Turkmenistan</OPTION>
<OPTION value=TCA>Turks And Caicos Islands</OPTION>
<OPTION value=TUV>Tuvalu</OPTION>
<OPTION value=UGA>Uganda</OPTION>
<OPTION value=UKR>Ukraine</OPTION>
<OPTION value=ARE>United Arab Emirates</OPTION>
<OPTION value=GBR>United Kingdom</OPTION>
<OPTION value=UMI>United States Minor Outlying Islands</OPTION>
<OPTION value=URY>Uruguay</OPTION>
<OPTION value=UZB>Uzbekistan</OPTION>
<OPTION value=VUT>Vanuatu</OPTION>
<OPTION value=VAT>Vatican City State (Holy See)</OPTION>
<OPTION value=VEN>Venezuela</OPTION>
<OPTION value=VNM>Viet Nam</OPTION>
<OPTION value=VGB>Virgin Islands (British)</OPTION>
<OPTION value=VIR>Virgin Islands (U.S.)</OPTION>
<OPTION value=WLF>Wallis And Futuna Islands</OPTION>
<OPTION value=ESH>Western Sahara</OPTION>
<OPTION value=YEM>Yemen</OPTION>
<OPTION value=YUG>Yugoslavia</OPTION>
<OPTION value=ZMB>Zambia</OPTION>
<OPTION value=ZWE>Zimbabwe</OPTION>
</SELECT>
 
It just gets ignored.
Anyone have a clue how to solve this?
What am I missing?

Batoe
User avatar
greyhoundcode
Forum Regular
Posts: 613
Joined: Mon Feb 11, 2008 4:22 am

Re: My select box is not adding data to MySQL?

Post by greyhoundcode »

You seem to be missing the PHP code :roll:

HTML <select> will not send anything to your database by itself!
User avatar
cap2cap10
Forum Contributor
Posts: 158
Joined: Mon Apr 14, 2008 11:06 pm

Re: My select box is not adding data to MySQL?

Post by cap2cap10 »

:dubious: I was wondering if there was anything wrong with the select box. Here is the total code:

Code: Select all

<?php
include 'form_top1.htm';
 
echo "<table  border=0> <tr><td valign=top width=350 >
<div>
<fieldset style=padding-left:18px; bgcolor=#00FF33> <legend><span class=style1>Log-in info: </span></legend>
<form method=POST action=check_input1.php>
<span class=style4><IMG height=10 src=images/arrow_orange_trans.jpg                         width=12>Username:<BR>
<input name=username type=text   size=30 tabindex=1 maxlength=30><BR>
<IMG height=10 src=images/arrow_orange_trans.jpg                         width=12>Password:<BR>
<input name=password type=password  size=30 tabindex=2 maxlength=30><BR>
<IMG height=10 src=images/arrow_orange_trans.jpg                         width=12>Confirm Password:<BR>
<input name=conf_password type=PASSWORD  size=30 tabindex=3 maxlength=30><BR>
<IMG height=10 src=images/arrow_orange_trans.jpg                         width=12>First Name: <BR>
<input name=FName type=text  size=30 tabindex=4 maxlength=30><BR>
<IMG height=10 src=images/arrow_orange_trans.jpg                         width=12>Middle Name:<BR>
<input name=MName type=text size=30  tabindex=5 maxlength=30><BR>
<IMG height=10 src=images/arrow_orange_trans.jpg                         width=12>Last Name: <BR>
<input name=LName type=text size=30 tabindex=6 maxlength=30><BR>
<IMG height=10 src=images/arrow_orange_trans.jpg                         width=12>E-mail: <BR>
<input name=Email type=TEXT size=41 tabindex=7 maxlength=50><BR>
<IMG height=10 src=images/arrow_orange_trans.jpg                         width=12>Confirm Email: <BR>
<input name=conf_email type=text size=41 tabindex=8 maxlength=50></span><P>
</fieldset></td>
        <td width=350 valign=top height=350>
<fieldset style=padding-left:18px;> <legend><span class=style1>Account info: </span></legend><P>
<span class=style4><IMG height=10 src=images/arrow_orange_trans.jpg                         width=12>Address: <BR>
<INPUT name=Address type=text size=30 tabindex=9 maxlength=60><BR>
<span class=style4><IMG height=10 src=images/arrow_orange_trans.jpg                         width=12>Apartment/Suite: <BR>
<INPUT name=Suite type=text size=8 tabindex=10 maxlength=5><BR>
<IMG height=10 src=images/arrow_orange_trans.jpg                         width=12>City: <BR>
<INPUT name=City type=text  size=30  tabindex=11 maxlength=30><BR>
<IMG  src=images/arrow_orange_trans.jpg     height=10                    width=12>State/Province: <BR>
<INPUT name=State type=text  size=30  tabindex=12 maxlength=30><BR>
<IMG  src=images/arrow_orange_trans.jpg   height=10                      width=12>Zip Code:<BR>
<INPUT name=Zipcode type=text  size=30  tabindex=13 maxlength=20><BR>
<IMG  src=images/arrow_orange_trans.jpg  height=10                       width=12>Country: <BR>
<SELECT name=Country tabindex=14 >
<OPTION value=USA selected>United States</OPTION>
<OPTION value=CAN>Canada</OPTION>
<OPTION value=AFG>Afghanistan</OPTION>
<OPTION value=ALB>Albania</OPTION>
<OPTION value=DZA>Algeria</OPTION>
<OPTION value=ASM>American Samoa</OPTION>
<OPTION value=AND>Andorra</OPTION>
<OPTION value=AGO>Angola</OPTION>
<OPTION value=AIA>Anguilla</OPTION>
<OPTION value=ATA>Antarctica</OPTION>
<OPTION value=ATG>Antigua And Barbuda</OPTION>
<OPTION value=ARG>Argentina</OPTION>
<OPTION value=ARM>Armenia</OPTION>
<OPTION value=ABW>Aruba</OPTION>
<OPTION value=AUS>Australia</OPTION>
<OPTION value=AUT>Austria</OPTION>
<OPTION value=AZE>Azerbaijan</OPTION>
<OPTION value=BHS>Bahamas</OPTION>
<OPTION value=BHR>Bahrain</OPTION>
<OPTION value=BGD>Bangladesh</OPTION>
<OPTION value=BRB>Barbados</OPTION>
<OPTION value=BLR>Belarus</OPTION>
<OPTION value=BEL>Belgium</OPTION>
<OPTION value=BLZ>Belize</OPTION>
<OPTION value=BEN>Benin</OPTION>
<OPTION value=BMU>Bermuda</OPTION>
<OPTION value=BTN>Bhutan</OPTION>
<OPTION value=BOL>Bolivia</OPTION>
<OPTION value=BIH>Bosnia And Herzegovina</OPTION>
<OPTION value=BWA>Botswana</OPTION>
<OPTION value=BVT>Bouvet Island</OPTION>
<OPTION value=BRA>Brazil</OPTION>
<OPTION value=IOT>British Indian Ocean Territory</OPTION>
<OPTION value=BRN>Brunei Darussalam</OPTION>
<OPTION value=BGR>Bulgaria</OPTION>
<OPTION value=BFA>Burkina Faso</OPTION>
<OPTION value=BDI>Burundi</OPTION>
<OPTION value=KHM>Cambodia</OPTION>
<OPTION value=CMR>Cameroon</OPTION>
<OPTION value=CPV>Cape Verde</OPTION>
<OPTION value=CYM>Cayman Islands</OPTION>
<OPTION value=CAF>Central African Republic</OPTION>
<OPTION value=TCD>Chad</OPTION>
<OPTION value=CHL>Chile</OPTION>
<OPTION value=CHN>China</OPTION>
<OPTION value=CXR>Christmas Island</OPTION>
<OPTION value=CCK>Cocos (Keeling)Islands</OPTION>
<OPTION value=COL>Colombia</OPTION>
<OPTION value=COM>Comoros</OPTION>
<OPTION value=COG>Congo</OPTION>
<OPTION value=COK>Cook Islands</OPTION>
<OPTION value=CRI>Costa Rica</OPTION>
<OPTION value=CIV>Cote Divoire</OPTION>
<OPTION value=HRV>Croatia (Local Name: Hrvatska)</OPTION>
<OPTION value=CUB>Cuba</OPTION>
<OPTION value=CYP>Cyprus</OPTION>
<OPTION value=CZE>Czech  Republic</OPTION>
<OPTION value=ZAR>Democratic Republic of the Congo</OPTION>
<OPTION value=DNK>Denmark</OPTION>
<OPTION value=DJI>Djibouti</OPTION>
<OPTION value=DMA>Dominica</OPTION>
<OPTION value=DOM>Dominican Republic</OPTION>
<OPTION value=TMP>East Timor</OPTION>
<OPTION value=ECU>Ecuador</OPTION>
<OPTION value=EGY>Egypt</OPTION>
<OPTION value=SLV>El Salvador</OPTION>
<OPTION value=GNQ>Equatorial Guinea</OPTION>
<OPTION value=ERI>Eritrea</OPTION>
<OPTION value=EST>Estonia</OPTION>
<OPTION value=ETH>Ethiopia</OPTION>
<OPTION value=FLK>Falkland Islands (Malvinas)</OPTION>
<OPTION value=FRO>Faroe Islands</OPTION>
<OPTION value=FJI>Fiji</OPTION>
<OPTION value=FIN>Finland</OPTION>
<OPTION value=FRA>France</OPTION>
<OPTION value=GUF>French Guiana</OPTION>
<OPTION value=PYF>French Polynesia</OPTION>
<OPTION value=ATF>French Southern Territories</OPTION>
<OPTION value=GAB>Gabon</OPTION>
<OPTION value=GMB>Gambia</OPTION>
<OPTION value=GEO>Georgia</OPTION>
<OPTION value=DEU>Germany</OPTION>
<OPTION value=GHA>Ghana</OPTION>
<OPTION value=GIB>Gibraltar</OPTION>
<OPTION value=GRC>Greece</OPTION>
<OPTION value=GRL>Greenland</OPTION>
<OPTION value=GRD>Grenada</OPTION>
<OPTION value=GLP>Guadeloupe</OPTION>
<OPTION value=GUM>Guam</OPTION>
<OPTION value=GTM>Guatemala</OPTION>
<OPTION value=GIN>Guinea</OPTION>
<OPTION value=GNB>Guinea  Bissau</OPTION>
<OPTION value=GUY>Guyana</OPTION>
<OPTION value=HTI>Haiti</OPTION>
<OPTION value=HMB>Heard And Mc Donald Islands</OPTION>
<OPTION value=HND>Honduras</OPTION>
<OPTION value=HKG>Hong Kong</OPTION>
<OPTION value=HUN>Hungary</OPTION>
<OPTION value=ISL>Iceland</OPTION>
<OPTION value=IND>India</OPTION>
<OPTION value=IDN>Indonesia</OPTION>
<OPTION value=IRN>Iran (Islamic Republic Of)</OPTION>
<OPTION value=IRQ>Iraq</OPTION>
<OPTION value=IRL>Ireland</OPTION>
<OPTION value=ISR>Israel</OPTION>
<OPTION value=ITA>Italy</OPTION>
<OPTION value=JAM>Jamaica</OPTION>
<OPTION value=JPN>Japan</OPTION>
<OPTION value=JOR>Jordan</OPTION>
<OPTION value=KAZ>Kazakhstan</OPTION>
<OPTION value=KEN>Kenya</OPTION>
<OPTION value=KIR>Kiribati</OPTION>
<OPTION value=PRK>Korea, Democratic Peoples Republic OF</OPTION>
<OPTION value=KOR>Korea, Republic Of</OPTION>
<OPTION value=KWT>Kuwait</OPTION>
<OPTION value=KGZ>Kyrgyzstan</OPTION>
<OPTION value=LAO>Lao Peoples Democratic Republic</OPTION>
<OPTION value=LVA>Latvia</OPTION>
<OPTION value=LBN>Lebanon</OPTION>
<OPTION value=LSO>Lesotho</OPTION>
<OPTION value=LBR>Liberia</OPTION>
<OPTION value=LBY>Libyan Arab Jamahiriya</OPTION>
<OPTION value=LIE>Liechtenstein</OPTION>
<OPTION value=LTU>Lithuania</OPTION>
<OPTION value=LUX>Luxembourg</OPTION>
<OPTION value=MRC>Macau</OPTION>
<OPTION value=MKD>Macedonia</OPTION>
<OPTION value=MDG>Madagascar</OPTION>
<OPTION value=MWI>Malawi</OPTION>
<OPTION value=MYS>Malaysia</OPTION>
<OPTION value=MDV>Maldives</OPTION>
<OPTION value=MLI>Mali</OPTION>
<OPTION value=MLT>Malta</OPTION>
<OPTION value=MHL>Marshall Islands</OPTION>
<OPTION value=MTQ>Martinique</OPTION>
<OPTION value=MRT>Mauritania</OPTION>
<OPTION value=MUS>Mauritius</OPTION>
<OPTION value=MYT>Mayotte</OPTION>
<OPTION value=MEX>Mexico</OPTION>
<OPTION value=FSM>Micronesia, Federated States Of</OPTION>
<OPTION value=MDA>Moldova, Republic Of</OPTION>
<OPTION value=MCO>Monaco</OPTION>
<OPTION value=MNG>Mongolia</OPTION>
<OPTION value=MSR>Montserrat</OPTION>
<OPTION value=MAR>Morocco</OPTION>
<OPTION value=MOZ>Mozambique</OPTION>
<OPTION value=MMR>Myanmar</OPTION>
<OPTION value=NAM>Namibia</OPTION>
<OPTION value=NRU>Nauru</OPTION>
<OPTION value=NPL>Nepal</OPTION>
<OPTION value=NLD>Netherlands</OPTION>
<OPTION value=ANT>Netherlands Antilles</OPTION>
<OPTION value=NCL>New Caledonia</OPTION>
<OPTION value=NZL>New Zealand</OPTION>
<OPTION value=NIC>Nicaragua</OPTION>
<OPTION value=NER>Niger</OPTION>
<OPTION value=NGA>Nigeria</OPTION>
<OPTION value=NIU>Niue</OPTION>
<OPTION value=NFK>Norfolk Island</OPTION>
<OPTION value=MNP>Northern Mariana Islands</OPTION>
<OPTION value=NOR>Norway</OPTION>
<OPTION value=OMN>Oman</OPTION>
<OPTION value=PAK>Pakistan</OPTION>
<OPTION value=PLW>Palau</OPTION>
<OPTION value=PSE>Palestinian Territory, Occupied</OPTION>
<OPTION value=PAN>Panama</OPTION>
<OPTION value=PNG>Papua New Guinea</OPTION>
<OPTION value=PRY>Paraguay</OPTION>
<OPTION value=PER>Peru</OPTION>
<OPTION value=PHL>Philippines</OPTION>
<OPTION value=PCN>Pitcairn</OPTION>
<OPTION value=POL>Poland</OPTION>
<OPTION value=PRT>Portugal</OPTION>
<OPTION value=PRI>Puerto Rico</OPTION>
<OPTION value=QAT>Qatar</OPTION>
<OPTION value=REU>Reunion</OPTION>
<OPTION value=ROM>Romania</OPTION>
<OPTION value=RUS>Russian Federation</OPTION>
<OPTION value=RWA>Rwanda</OPTION>
<OPTION value=KNA>Saint Kitts And Nevis</OPTION>
<OPTION value=LCA>Saint Lucia</OPTION>
<OPTION value=VCT>Saint Vincent And The Grenadines</OPTION>
<OPTION value=WSM>Samoa</OPTION>
<OPTION value=SMR>San Marino</OPTION>
<OPTION value=STP>Sao Tome And Principe</OPTION>
<OPTION value=SAU>Saudi Arabia</OPTION>
<OPTION value=SEN>Senegal</OPTION>
<OPTION value=SME>Serbia and Montenegro</OPTION>
<OPTION value=SYC>Seychelles</OPTION>
<OPTION value=SLE>Sierra Leone</OPTION>
<OPTION value=SGP>Singapore</OPTION>
<OPTION value=SVK>Slovakia (Slovak Republic)</OPTION>
<OPTION value=SVN>Slovenia</OPTION>
<OPTION value=SLB>Solomon Islands</OPTION>
<OPTION value=SOM>Somalia</OPTION>
<OPTION value=ZAF>South Africa</OPTION>
<OPTION value=SGS>South Georgia</OPTION>
<OPTION value=ESP>Spain</OPTION>
<OPTION value=LKA>Sri Lanka</OPTION>
<OPTION value=SHN>St. Helena</OPTION>
<OPTION value=SPM>St. Pierre And Miquelon</OPTION>
<OPTION value=SDN>Sudan</OPTION>
<OPTION value=SUR>Suriname</OPTION>
<OPTION value=SJM>Svalbard And Jan Mayen Islands</OPTION>
<OPTION value=SWZ>Swaziland</OPTION>
<OPTION value=SWE>Sweden</OPTION>
<OPTION value=CHE>Switzerland</OPTION>
<OPTION value=SYR>Syrian Arab Republic</OPTION>
<OPTION value=TWN>Taiwan</OPTION>
<OPTION value=TJK>Tajikistan</OPTION>
<OPTION value=TZA>Tanzania, United Republic Of</OPTION>
<OPTION value=THA>Thailand</OPTION>
<OPTION value=TGO>Togo</OPTION>
<OPTION value=TKL>Tokelau</OPTION>
<OPTION value=TON>Tonga</OPTION>
<OPTION value=TTO>Trinidad And Tobago</OPTION>
<OPTION value=TUN>Tunisia</OPTION>
<OPTION value=TUR>Turkey</OPTION>
<OPTION value=TKM>Turkmenistan</OPTION>
<OPTION value=TCA>Turks And Caicos Islands</OPTION>
<OPTION value=TUV>Tuvalu</OPTION>
<OPTION value=UGA>Uganda</OPTION>
<OPTION value=UKR>Ukraine</OPTION>
<OPTION value=ARE>United Arab Emirates</OPTION>
<OPTION value=GBR>United Kingdom</OPTION>
<OPTION value=UMI>United States Minor Outlying Islands</OPTION>
<OPTION value=URY>Uruguay</OPTION>
<OPTION value=UZB>Uzbekistan</OPTION>
<OPTION value=VUT>Vanuatu</OPTION>
<OPTION value=VAT>Vatican City State (Holy See)</OPTION>
<OPTION value=VEN>Venezuela</OPTION>
<OPTION value=VNM>Viet Nam</OPTION>
<OPTION value=VGB>Virgin Islands (British)</OPTION>
<OPTION value=VIR>Virgin Islands (U.S.)</OPTION>
<OPTION value=WLF>Wallis And Futuna Islands</OPTION>
<OPTION value=ESH>Western Sahara</OPTION>
<OPTION value=YEM>Yemen</OPTION>
<OPTION value=YUG>Yugoslavia</OPTION>
<OPTION value=ZMB>Zambia</OPTION>
<OPTION value=ZWE>Zimbabwe</OPTION>
</SELECT> <BR>
<IMG height=10 src=images/arrow_orange_trans.jpg width=12>Home Phone: <BR>
(<INPUT name=Hphone_1 size=3 type=textbox maxlength=3 tabindex=15>) - <INPUT name=Hphone_2 size=3 type=textbox maxlength=3 tabindex=16> - <INPUT name=Hphone_3 size=4 type=textbox maxlength=4 tabindex=17><br>
<IMG height=10 src=images/arrow_orange_trans.jpg width=12>Mobile Phone: <BR>
(<INPUT name=Mphone_1 size=3 type=textbox maxlength=3 tabindex=18>) - <INPUT name=Mphone_2 size=3 type=textbox maxlength=3 tabindex=19> - <INPUT name=Mphone_3 size=4 type=textbox maxlength=4 tabindex=20><br>
 
<IMG height=10 src=images/arrow_orange_trans.jpg width=12>Work Phone: (optional)<BR>
(<INPUT name=Wphone_1 size=3 type=textbox maxlength=3 tabindex=21>) - <INPUT name=Wphone_2 size=3 type=textbox maxlength=3 tabindex=22> - <INPUT name=Wphone_3 size=4 type=textbox maxlength=4 tabindex=23> Ext: <INPUT name=Extension size=5 type=textbox maxlength=5 tabindex=24><p>
 
<P>&nbsp;<P> <P></fieldset></td>
    </tr>
    <tr>
    <td colspan=2 align=right>
    <input type=hidden name=submitted value=true />
    <input type=submit name=submit value=Register />
    <input type=reset name=Reset value=Reset /></form></td>     </tr> </table>";
 
include'footer.html';
?>
ok what do you guys think?

Batoe
User avatar
califdon
Jack of Zircons
Posts: 4484
Joined: Thu Nov 09, 2006 8:30 pm
Location: California, USA

Re: My select box is not adding data to MySQL?

Post by califdon »

You have no code to interact with any database. You really need to study how to do that. It requires a lot of additional code and is totally dependent on how you have set up your database and whether you want to use one or two PHP scripts. Indeed, you are not using PHP for anything at all useful in that script, you just have one exceedingly long echo statement that does no more than regular HTML would, except it will run slower, since it has to be parsed by PHP. There is no way we can show you how to do this, in a forum. Read http://w3schools.com/php/default.asp and http://w3schools.com/php/php_mysql_intro.asp, to start with.
User avatar
cap2cap10
Forum Contributor
Posts: 158
Joined: Mon Apr 14, 2008 11:06 pm

Re: My select box is not adding data to MySQL?

Post by cap2cap10 »

:dubious: Actually the form action leads to a validation/ mysql include files. So I do have code that will interact with the database. My question is why the select box is not being seen at all when I select an option.
The next script check_input. php posts the variables, which gives the user a chance to go back and change input data before it is uploaded to the DB table.

So again, why is my select box being ignored?

Any takers?
matthijs
DevNet Master
Posts: 3360
Joined: Thu Oct 06, 2005 3:57 pm

Re: My select box is not adding data to MySQL?

Post by matthijs »

I think the select box has been bad and the others are angry with him.

But serious, have you done an var_dump($_POST) or something in the target script to see what's being posted there? Maybe it's just a spelling mistake
User avatar
greyhoundcode
Forum Regular
Posts: 613
Joined: Mon Feb 11, 2008 4:22 am

Re: My select box is not adding data to MySQL?

Post by greyhoundcode »

I didn't mean to sound sarcastic earlier :lol: Here is a simplified version of your select form that does work:

Code: Select all

// TEST.php
 
<form method="post" action="test.php">
    <select name="Country">
        <option value="USA">United States</option>
        <option value="CAN">Canada</option>
        <option value="AFG">Afghanistan</option>
    </select>
    <input type="submit" name="submit" value="Test me">
</form>
 
<?php
if (isset($_POST['Country']))
{
    // This correctly returns the selected country value:
    echo $_POST['Country'];
}
?>
Although I didn't see it in your original post I assume you did set up the form tags with method and action attributes? Also it is best practice to write tags in lower case and quote any attributes within the tags. If you are outputting XHTML this might been one part of the problem if not the complete solution.
Post Reply