timmah1 Posted December 1, 2007 Share Posted December 1, 2007 I'm having a problem with this form. If you don't fill out the required fields, it pushed everything to the right, I've been racking my brains trying to figure this out, so I thought I'd come to the reliable help from the the board. Please help if you can register page <? include 'DB_config.php'; echo " <table width=\"584\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" background=\"./images/welcomebg.gif\" class=\"text\"> <tr> <td><img src=\"./images/Registration.png\"></td> </tr> <tr> <td>"; if ($register =="yes") { $email = $_POST['email']; $password = $_POST['password']; $password2 = $_POST['password2']; $first = $_POST['first']; $last = $_POST['last']; $address = $_POST['address']; $city = $_POST['city']; $state = $_POST['state']; $zip = $_POST['zip']; $category = $_POST['category']; $title = $_POST['title']; if((!$email) || (!$password) || (!$password2) || (!$first) || (!$last) || (!$address) || (!$city) || (!$state) || (!$zip) || (!$category) || (!$title)) { echo 'You did not submit the following required information! <br />'; if(!$email){ echo "<font color=FF0000>You must provide a valid email.</font><br />"; } if(!$password){ echo "<font color=FF0000>You must provide a password.</font><br />"; } if(!$password2){ echo "<font color=FF0000>Passwords do not match.</font><br />"; } if(!$first){ echo "<font color=FF0000>We need to know your first name.</font><br />"; } if(!$last){ echo "<font color=FF0000>We need to know your last name.</font><br />"; } if(!$address){ echo "<font color=FF0000>We need to know your address.</font><br />"; } if(!$city){ echo "<font color=FF0000>You must provide a city.</font><br />"; } if(!$state){ echo "<font color=FF0000>You must provide a state.</font><br />"; } if(!$zip){ echo "<font color=FF0000>Your zip code must be provied.</font><br />"; } if(!$category){ echo "<font color=FF0000>You need to let us know what category.</font><br />"; } if(!$title){ echo "<font color=FF0000>We need to have a title.</font><br />"; } echo " </td> </tr> </table>"; // Show the form again! include "form.php"; exit(); // if the error checking has failed, we'll exit the script! } /* End the error checking and if everything is ok, we'll move on to creating the user account */ ?> <table width="584" border="0" cellspacing="0" cellpadding="0" background="./images/welcomebg.gif" class="text"> <tr> <td><img src="./images/Registration.png"></td> </tr> <tr> <td> <? $check = "select * from users where email = '".$_POST['email']."';"; $qry = mysql_query($check) or die ("Could not match data because ".mysql_error()); $num_rows = mysql_num_rows($qry); if ($num_rows != 0) { echo "You are already registered. If you forgot your password, click here.<br>"; exit; } $ip = $REMOTE_ADDR; $insert = mysql_query("insert into users values ('NULL',NOW(),'$ip','".$_POST["email"]."',"."PASSWORD('".$_POST["password"]."'),'".$_POST["business"]."','".$_POST["first"]."','".$_POST["last"]."','".$_POST["address1"]."','".$_POST["address2"]."','".$_POST["city"]."','".$_POST["county"]."','".$_POST["state"]."','".$_POST["country"]."','".$_POST["zip"]."','".$_POST["phone"]."','".$_POST["fax"]."','".$_POST["mobile"]."','".$_POST["web"]."','".$_POST["position"]."','".$_POST["news"]."','".$_POST["format"]."','".$_POST["category"]."','".$_POST["title"]."','".$_POST["desc"]."','n','y')") or die("Sorry, there was a problem creating your account ".mysql_error()); echo "Your account has been setup.<br>"; } include "form.php"; ?> </td> </tr> </table> form <form name="foobar" method="post" action="?cid=register"> <table cellpadding="5" cellspacing="5" background="./images/welcomebg.gif" class="text"> <tr> <td colspan=2 style="font-weight:bold;font-size: 14px;"> Fields marked with * are required. </td> </tr> <tr> <td> Email* </td> <td><input type="text" name="email" size=30 maxlength=80 value="<? echo "$_POST[email]"; ?>"> <span class="instruction"><a href="help/help.php#stealth" target="_blank"></a></span> </td> </tr> <tr> <td> Password* </td> <td> <input type="password" name="password" size=15 maxlength=15 value=""> <span class="instruction">[enter any SINGLE WORD password you wish (up to 15 characters)]</span> </td> </tr> <tr> <td> Confirm<br> Password* </td> <td> <input type="password" name="confirm_password" size=15 maxlength=15 value=""> <span class="instruction">[confirm the password you entered above]</span> </td> </tr> <tr> <td> Business* </td> <td> <input type="text" name="business" size=30 maxlength=45 value="<? echo "$_POST[business]"; ?>"> </td> </tr> <tr> <td> First Name </td> <td> <input type="text" name="first" size=30 maxlength=35 value="<? echo "$_POST[first]"; ?>"> </td> </tr> <tr> <td> Last Name </td> <td> <input type="text" name="last" size=30 maxlength=45 value="<? echo "$_POST[lastl]"; ?>"> </td> </tr> <tr> <td> Address* </td> <td> <input type="text" name="address1" size=30 maxlength=70 value="<? echo "$_POST[address]"; ?>"> </td> </tr> <tr> <td> Address 2 </td> <td> <input type="text" name="address2" size=30 maxlength=70 value="<? echo "$_POST[address2]"; ?>"> </td> </tr> <tr> <td> City *</td> <td> <input type="text" name="city" size=30 maxlength=25 value="<? echo "$_POST[city]"; ?>"> </td> </tr> <tr> <td> County </td> <td> <input type="text" name="county" size=30 maxlength=80 value="<? echo "$_POST[county]"; ?>"> </td> </tr> <tr> <td> State *</td> <td> <!-- subjurisdiction.php --> <!-- sjUSA.php --> <select name="state" size=1> <option value="" SELECTED></option> <option value="*"> – All United States – </option> <option value="AL">Alabama</option> <option value="AK">Alaska</option> <option value="AZ">Arizona</option> <option value="AR">Arkansas</option> <option value="CA">California</option> <option value="CO">Colorado</option> <option value="CT">Connecticut</option> <option value="DE">Delaware</option> <option value="DC">District of Columbia</option> <option value="FL">Florida</option> <option value="GA">Georgia</option> <option value="HI">Hawaii</option> <option value="ID">Idaho</option> <option value="IL">Illinois</option> <option value="IN">Indiana</option> <option value="IA">Iowa</option> <option value="KS">Kansas</option> <option value="KY">Kentucky</option> <option value="LA">Louisiana</option> <option value="ME">Maine</option> <option value="MD">Maryland</option> <option value="MA">Massachusetts</option> <option value="MI">Michigan</option> <option value="MN">Minnesota</option> <option value="MS">Mississippi</option> <option value="MO">Missouri</option> <option value="MT">Montana</option> <option value="NE">Nebraska</option> <option value="NV">Nevada</option> <option value="NH">New Hampshire</option> <option value="NJ">New Jersey</option> <option value="NM">New Mexico</option> <option value="NY">New York</option> <option value="NC">North Carolina</option> <option value="ND">North Dakota</option> <option value="OH">Ohio</option> <option value="OK">Oklahoma</option> <option value="OR">Oregon</option> <option value="PA">Pennsylvania</option> <option value="RI">Rhode Island</option> <option value="SC">South Carolina</option> <option value="SD">South Dakota</option> <option value="TN">Tennessee</option> <option value="TX">Texas</option> <option value="UT">Utah</option> <option value="VT">Vermont</option> <option value="VA">Virginia</option> <option value="WA">Washington</option> <option value="WV">West Virginia</option> <option value="WI">Wisconsin</option> <option value="WY">Wyoming</option> </select> <!-- sjUSA.php --><!-- subjurisdiction.php --> </td> </tr> <tr> <td> Country </td> <td> <!-- START of countries.php --> <select name='country'> <option value="" SELECTED></option> <option value='United States'>United States</option> <option value=''>- - - - - - - - - - - - </option> <option value=''>All countries</option> <option value=''>- - - - - - - - - - - - </option> <!-- Add, remove or change any of the select option items below. --> <option value='Afghanistan'>Afghanistan</option> <option value='Albania'>Albania</option> <option value='Algeria'>Algeria</option> <option value='American Samoa'>American Samoa</option> <option value='Andorra'>Andorra</option> <option value='Angola'>Angola</option> <option value='Anguilla'>Anguilla</option> <option value='Antarctica'>Antarctica</option> <option value='Antigua and Barbuda'>Antigua and Barbuda</option> <option value='Argentina'>Argentina</option> <option value='Armenia'>Armenia</option> <option value='Aruba'>Aruba</option> <option value='Ashmore and Cartier Islands'>Ashmore Islands</option> <option value='Australia'>Australia</option> <option value='Austria'>Austria</option> <option value='Azerbaijan'>Azerbaijan</option> <option value='Bahrain'>Bahrain</option> <option value='Baker Island'>Baker Island</option> <option value='Bangladesh'>Bangladesh</option> <option value='Barbados'>Barbados</option> <option value='Bassas da India'>Bassas da India</option> <option value='Belarus'>Belarus</option> <option value='Belgium'>Belgium</option> <option value='Belize'>Belize</option> <option value='Benin'>Benin</option> <option value='Bermuda'>Bermuda</option> <option value='Bhutan'>Bhutan</option> <option value='Bolivia'>Bolivia</option> <option value='Bosnia - Herzegovina'>Bosnia - Herzegovina</option> <option value='Botswana'>Botswana</option> <option value='Bouvet Island'>Bouvet Island</option> <option value='Brazil'>Brazil</option> <option value='British Indian Ocean Territory'>B.I.O.Territory</option> <option value='British Virgin Islands'>British Virgin Islands</option> <option value='Brunei'>Brunei</option> <option value='Bulgaria'>Bulgaria</option> <option value='Burkina Faso'>Burkina Faso</option> <option value='Burma'>Burma</option> <option value='Burundi'>Burundi</option> <option value='Cambodia'>Cambodia</option> <option value='Cameroon'>Cameroon</option> <option value='Canada'>Canada</option> <option value='Cape Verde'>Cape Verde</option> <option value='Cayman Islands'>Cayman Islands</option> <option value='Central African Republic'>Central African Rep.</option> <option value='Chad'>Chad</option> <option value='Chile'>Chile</option> <option value='China'>China</option> <option value='Christmas Island'>Christmas Island</option> <option value='Clipperton Island'>Clipperton Island</option> <option value='Cocos (Keeling) Islands'>Cocos Islands</option> <option value='Colombia'>Colombia</option> <option value='Comoros'>Comoros</option> <option value='Congo'>Congo</option> <option value='Cook Islands'>Cook Islands</option> <option value='Coral Sea Islands'>Coral Sea Islands</option> <option value='Costa Rica'>Costa Rica</option> <option value='Cote d'Ivoire'>Cote d'Ivoire</option> <option value='Croatia'>Croatia</option> <option value='Cuba'>Cuba</option> <option value='Cyprus'>Cyprus</option> <option value='Czech Republic'>Czech Republic</option> <option value='Denmark'>Denmark</option> <option value='Djibouti'>Djibouti</option> <option value='Dominica'>Dominica</option> <option value='Dominican Republic'>Dominican Republic</option> <option value='Ecuador'>Ecuador</option> <option value='Egypt'>Egypt</option> <option value='El Salvador'>El Salvador</option> <option value='Equatorial Guinea'>Equatorial Guinea</option> <option value='Eritrea'>Eritrea</option> <option value='Estonia'>Estonia</option> <option value='Ethiopia'>Ethiopia</option> <option value='Europa Island'>Europa Island</option> <option value='Falkland Islands (Islas Malvinas)'>Falkland Islands</option> <option value='Faroe Islands'>Faroe Islands</option> <option value='Fiji'>Fiji</option> <option value='Finland'>Finland</option> <option value='France'>France</option> <option value='French Guiana'>French Guiana</option> <option value='French Polynesia'>French Polynesia</option> <option value='Gabon'>Gabon</option> <option value='Gaza Strip'>Gaza Strip</option> <option value='Georgia'>Georgia</option> <option value='Germany'>Germany</option> <option value='Ghana'>Ghana</option> <option value='Gibraltar'>Gibraltar</option> <option value='Glorioso Islands'>Glorioso Islands</option> <option value='Greece'>Greece</option> <option value='Greenland'>Greenland</option> <option value='Grenada'>Grenada</option> <option value='Guadeloupe'>Guadeloupe</option> <option value='Guam'>Guam</option> <option value='Guatemala'>Guatemala</option> <option value='Guernsey'>Guernsey</option> <option value='Guinea'>Guinea</option> <option value='Guinea-Bissau'>Guinea-Bissau</option> <option value='Guyana'>Guyana</option> <option value='Haiti'>Haiti</option> <option value='Heard Island and McDonald Islands'>Heard Island</option> <option value='Vatican City'>Vatican City</option> <option value='Honduras'>Honduras</option> <option value='Hong Kong'>Hong Kong</option> <option value='Howland Island'>Howland Island</option> <option value='Hungary'>Hungary</option> <option value='Iceland'>Iceland</option> <option value='India'>India</option> <option value='Indonesia'>Indonesia</option> <option value='Iran'>Iran</option> <option value='Iraq'>Iraq</option> <option value='Ireland'>Ireland</option> <option value='Israel'>Israel</option> <option value='Italy'>Italy</option> <option value='Jamaica'>Jamaica</option> <option value='Jan Mayen'>Jan Mayen</option> <option value='Japan'>Japan</option> <option value='Jarvis Island'>Jarvis Island</option> <option value='Jersey'>Jersey</option> <option value='Johnston Atoll'>Johnston Atoll</option> <option value='Jordan'>Jordan</option> <option value='Juan de Nova Island'>Juan de Nova Island</option> <option value='Kazakstan'>Kazakstan</option> <option value='Kenya'>Kenya</option> <option value='Kingman Reef'>Kingman Reef</option> <option value='Kiribati'>Kiribati</option> <option value='Korea, North'>Korea, North</option> <option value='Korea, South'>Korea, South</option> <option value='Kuwait'>Kuwait</option> <option value='Kyrgyzstan'>Kyrgyzstan</option> <option value='Laos'>Laos</option> <option value='Latvia'>Latvia</option> <option value='Lebanon'>Lebanon</option> <option value='Lesotho'>Lesotho</option> <option value='Liberia'>Liberia</option> <option value='Libya'>Libya</option> <option value='Liechtenstein'>Liechtenstein</option> <option value='Lithuania'>Lithuania</option> <option value='Luxembourg'>Luxembourg</option> <option value='Macau'>Macau</option> <option value='Macedonia, The Former Yugoslav Republic of'>Macedonia</option> <option value='Madagascar'>Madagascar</option> <option value='Malawi'>Malawi</option> <option value='Malaysia'>Malaysia</option> <option value='Maldives'>Maldives</option> <option value='Mali'>Mali</option> <option value='Malta'>Malta</option> <option value='Man, Isle of'>Man, Isle of</option> <option value='Marshall Islands'>Marshall Islands</option> <option value='Martinique'>Martinique</option> <option value='Mauritania'>Mauritania</option> <option value='Mauritus'>Mauritus</option> <option value='Mayotte'>Mayotte</option> <option value='Mexico'>Mexico</option> <option value='Micronesia, Federated States of'>Micronesia</option> <option value='Midway Islands'>Midway Islands</option> <option value='Moldova'>Moldova</option> <option value='Monaco'>Monaco</option> <option value='Mongolia'>Mongolia</option> <option value='Montserrat'>Montserrat</option> <option value='Morocco'>Morocco</option> <option value='Mozambique'>Mozambique</option> <option value='Namibia'>Namibia</option> <option value='Nauru'>Nauru</option> <option value='Navassa Island'>Navassa Island</option> <option value='Nepal'>Nepal</option> <option value='Netherlands'>Netherlands</option> <option value='Netherlands Antilles'>Netherlands Antilles</option> <option value='New Caledonia'>New Caledonia</option> <option value='New Zealand'>New Zealand</option> <option value='Nicaragua'>Nicaragua</option> <option value='Niger'>Niger</option> <option value='Nigeria'>Nigeria</option> <option value='Niue'>Niue</option> <option value='Norfolk Island'>Norfolk Island</option> <option value='Norther Mariana Islands'>N. Mariana Is.</option> <option value='Norway'>Norway</option> <option value='Oman'>Oman</option> <option value='Pakistan'>Pakistan</option> <option value='Palau'>Palau</option> <option value='Palmyra Atoll'>Palmyra Atoll</option> <option value='Republic of Panama'>Republic of Panama</option> <option value='Papua New Guinea'>Papua New Guinea</option> <option value='Paracel Islands'>Paracel Islands</option> <option value='Paraguay'>Paraguay</option> <option value='Peru'>Peru</option> <option value='Philippines'>Philippines</option> <option value='Pitcairn Islands'>Pitcairn Islands</option> <option value='Poland'>Poland</option> <option value='Portugal'>Portugal</option> <option value='Puerto Rico'>Puerto Rico</option> <option value='Qatar'>Qatar</option> <option value='Reunion'>Reunion</option> <option value='Romania'>Romania</option> <option value='Russia'>Russia</option> <option value='Rwanda'>Rwanda</option> <option value='Saint Helena'>Saint Helena</option> <option value='Saint Kitts and Nevis'>Saint Kitts and Nevis</option> <option value='Saint Lucia'>Saint Lucia</option> <option value='Saint Pierre and Miquelon'>Saint Pierre</option> <option value='Saint Vincent and the Grenadines'>Saint Vincent</option> <option value='San Marino'>San Marino</option> <option value='Sao Tome and Principe'>Sao Tome</option> <option value='Saudi Arabia'>Saudi Arabia</option> <option value='Senegal'>Senegal</option> <option value='Serbia and Montenegro'>Serbia - Montenegro</option> <option value='Seychelles'>Seychelles</option> <option value='Sierra Leone'>Sierra Leone</option> <option value='Singapore'>Singapore</option> <option value='Slovakia'>Slovakia</option> <option value='Slovenia'>Slovenia</option> <option value='Solomon Islands'>Solomon Islands</option> <option value='Somalia'>Somalia</option> <option value='South Africa'>South Africa</option> <option value='South Georgia'>South Georgia</option> <option value='Spain'>Spain</option> <option value='Spratly Islands'>Spratly Islands</option> <option value='Sri Lanka'>Sri Lanka</option> <option value='Sudan'>Sudan</option> <option value='Suriname'>Suriname</option> <option value='Svalbard'>Svalbard</option> <option value='Swaziland'>Swaziland</option> <option value='Sweden'>Sweden</option> <option value='Switzerland'>Switzerland</option> <option value='Syria'>Syria</option> <option value='Taiwan'>Taiwan</option> <option value='Tajikistan'>Tajikistan</option> <option value='Tanzania'>Tanzania</option> <option value='Thailand'>Thailand</option> <option value='The Bahamas'>The Bahamas</option> <option value='The Gambia'>The Gambia</option> <option value='Tinidad and Tobago'>Tinidad and Tobago</option> <option value='Togo'>Togo</option> <option value='Tokelau'>Tokelau</option> <option value='Tonga'>Tonga</option> <option value='Tromelin Island'>Tromelin Island</option> <option value='Tunisia'>Tunisia</option> <option value='Turkey'>Turkey</option> <option value='Turkmenistan'>Turkmenistan</option> <option value='Turks and Caicos Islands'>Turks - Caicos Is.</option> <option value='Tuvalu'>Tuvalu</option> <option value='Uganda'>Uganda</option> <option value='Ukraine'>Ukraine</option> <option value='United Arab Emirates'>United Arab Emirates</option> <option value='United Kingdom'>United Kingdom</option> <option value='United States'>United States</option> <option value='Uruguay'>Uruguay</option> <option value='Uzbekistan'>Uzbekistan</option> <option value='Vanuatu'>Vanuatu</option> <option value='Venezuela'>Venezuela</option> <option value='Vietnam'>Vietnam</option> <option value='Virgin Islands'>Virgin Islands</option> <option value='Wake Island'>Wake Island</option> <option value='Wallis and Futuna'>Wallis and Futuna</option> <option value='West Bank'>West Bank</option> <option value='Western Sahara'>Western Sahara</option> <option value='Western Samoa'>Western Samoa</option> <option value='Yemen'>Yemen</option> <option value='Zaire'>Zaire</option> <option value='Zambia'>Zambia</option> <option value='Zimbabwe'>Zimbabwe</option> </select> <!-- END of countries.php --> </td> </tr> <tr> <td> Zipcode* </td> <td> <input type="text" name="zip" size=10 maxlength=10 value="<? echo "$_POST[zip]"; ?>"> </td> </tr> <tr> <td> Phone </td> <td> <input type="text" name="phone" size=20 maxlength=20 value="<? echo "$_POST[phone]"; ?>"> </td> </tr> <tr> <td> Fax </td> <td> <input type="text" name="fax" size=20 maxlength=20 value="<? echo "$_POST[fax]"; ?>"> </td> </tr> <tr> <td> Mobile </td> <td> <input type="text" name="mobile" size=20 maxlength=20 value="<? echo "$_POST[mobile]"; ?>"> </td> </tr> <tr> <td> Website </td> <td> <input type="text" name="web" size=25 maxlength=140 value="<? echo "$_POST[web]"; ?>"> <span class="instruction">Example: http://www.yourdomain.com</span> </td> </tr> <tr> <td> Position </td> <td> <!-- start of position.php --> <SELECT NAME="position" SIZE="1"> <OPTION VALUE="No match" SELECTED>No match</OPTION> <option VALUE="CEO">CEO</option> <option VALUE="Developer">Developer</option> <option VALUE="Director">Director</option> <option VALUE="Manager">Manager</option> <OPTION VALUE="Marketer">Marketer</OPTION> <option VALUE="Owner">Owner</option> <option VALUE="President">President</option> <option VALUE="Staff">Staff</option> <option VALUE="Webmaster">Webmaster</option> <option VALUE="No match">No match</option> </SELECT> <!-- end of position.php --> </td> </tr> <tr> <td> Newsletter </td> <td> <input type="checkbox" name="news" value="yes"> <span class="instruction">OK send infrequent MyAreaBartender.com news</span> </td> </tr> <tr> <td> News format </td> <td> <input type="radio" name="format" value="plain" CHECKED> plain <input type="radio" name="format" value="html"> html (if available) </td> </tr> <input type="hidden" name="instapayUserChoice" value="required"> <tr> <td valign="top"> Category* </td> <td valign="top"> <select name="category"> <option value="Bartenders">Bartenders</option> <option value="Lounges">Lounges</option> <option value="Restaurants">Restaurants</option> </select> <br /> <span class="instruction">Pick the MAIN category of your business.</span> </td> </tr> <tr> <td> Ad Title *</td> <td> <input type="text" name="title" size=60 maxlength=80 value="<? echo "$_POST[title]"; ?>"><br /> <span class="instruction">Example: Unique selling point (USP) of product or service</span> </td> </tr> <!-- description field - has textarea character counter - start --> <tr> <td valign="top"> Description </td> <td> <textarea onKeyDown="textCounter(document.foobar.description,document.foobar.remLen1,640)" onKeyUp="textCounter(document.foobar.description,document.foobar.remLen1,640)" name="desc" cols="40" rows="8"><? echo "$_POST[desc]"; ?></textarea> <br /> <span class="instruction">You can edit this later, if you wish.</span> <br /> <input readonly type="text" name="remLen1" size="3" maxlength="3" value="640"> <span class="instruction">characters left</span> </td> </tr> <!-- description field - has textarea character counter - end --> <tr class="favcolor2"> <td colspan=2> <input class="submit" type="submit" name="submit" value="Register"> <input type="hidden" name="register" value="yes" /></td> </tr> </table> </form> Thank you in advance for any help Link to comment https://forums.phpfreaks.com/topic/79646-solved-form-help/ Share on other sites More sharing options...
timmah1 Posted December 1, 2007 Author Share Posted December 1, 2007 Nevermind, I got it to work Link to comment https://forums.phpfreaks.com/topic/79646-solved-form-help/#findComment-403362 Share on other sites More sharing options...
marcus Posted December 1, 2007 Share Posted December 1, 2007 gg, mark as solve. Link to comment https://forums.phpfreaks.com/topic/79646-solved-form-help/#findComment-403363 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.