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 Quote Link to comment Share on other sites More sharing options...
timmah1 Posted December 1, 2007 Author Share Posted December 1, 2007 Nevermind, I got it to work Quote Link to comment Share on other sites More sharing options...
marcus Posted December 1, 2007 Share Posted December 1, 2007 gg, mark as solve. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.