http://85.17.200.148/~hostsite/xpress-host.eu/test2.php
een simpel scripje maar ik krijg volgende error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'land'),'webhosting','','domeinoptie','betaling')' at line 1
mijn scripts is :
heb al van alles geprobeerd en veranderd het lukt me niet
<?php
mysql_connect('localhost','hostsite_***','******');
mysql_select_db('hostsite_***') or die (mysql_error());
if(isset($_POST['verzenden']))
{
$username = addslashes($_POST['username']);
$paswoord = addslashes($_POST['paswoord']);
$email = addslashes($_POST['email']);
$voornaam = addslashes($_POST['voornaam']);
$achternaam = addslashes($_POST['achternaam']);
$straatnaam = addslashes($_POST['straatnaam']);
$huisnummer = addslashes($_POST['huisnummer']);
$postcode = addslashes($_POST['postcode']);
$gemeente = addslashes($_POST['gemeente']);
$land = addslashes($_POST['land']);
$webhosting = addslashes($_POST['webhosting']);
$domein = addslashes($_POST['domein']);
$domeinoptie = addslashes($_POST['domeinoptie']);
$betaling = addslashes($_POST['betaling']);
mysql_query("INSERT INTO formulier (username,paswoord,email,voornaam,achternaam,huisnummer,postocode,gemeente,land,webhosting, domein,domeinoptie,betaling) VALUES ('".$username."','".$paswoord."','".$email."','".$voornaam."','".$achternaam.", '".$straatnaam."','".$huisnummer."','".$postcode."','".$gemeente."','".$land."'),'".$webhosting."','".$domein."','".$domeinoptie."','".$betaling."')") or die (mysql_error());
echo 'Je gegevens zijn succesvol in de database geplaatst je krijgt een email zodra je bestelling is verwerkt door een medewerker';
}
else
{
?>
<style type="text/css">
<!--
.style2 {color: #FFFFFF}
-->
</style>
<form action=" <?=$_SERVER['PHP_SELF']?> " method="POST">
<p>Account Gegevens :</p>
<p>Username:
<input type="text" name="username" id="username">
</p>
<p><br />
Paswoord:
<input type="password" name="paswoord" id="paswoord">
</p>
<p><br />
Emailadres
<input type="text" name="email" id="email">
</p>
<p>Persoonlijke gegevens : </p>
<p>Voornaam:<span class="style2">::</span>
<label>
<input type="text" name="voornaam" id="voornaam">
</label>
achternaam :
<label>
<input type="text" name="achternaam" id="achternaam">
</label>
</p>
<p>straatnaam :
<label>
<input type="text" name="straatnaam" id="straatnaam">
</label>
huisnummer :
<label>
<input type="text" name="huisnummer" id="huisnummer">
</label>
</p>
<p>Postcode :<span class="style2">:::</span>
<label>
<input type="text" name="postcode" id="postcode">
gemeente :<span class="style2">::::</span> </label>
<label>
<input type="text" name="gemeente" id="gemeente">
</label>
</p>
<p>Land : <span class="style2">::::::::::</span>
<select name="land" id="land">
<option>United States of America</option>
<option>United States Minor Outlying Islands</option>
<option>United Kingdom</option>
<option>Canada</option>
<option>Australia</option>
<option>New Zealand</option>
<option>Afghanistan</option>
<option>Albania</option>
<option>American Samoa</option>
<option>Andorra</option>
<option>Angola</option>
<option>Anguilla</option>
<option>Antarctica</option>
<option>Antigua and Barbuda</option>
<option>Argentina</option>
<option>Armenia</option>
<option>Aruba</option>
<option>Aruba</option>
<option>Austria</option>
<option>Austria</option>
<option>Azerbaijan</option>
<option>Bahamas</option>
<option>Bahrain</option>
<option>Barbados</option>
<option>Barbados</option>
<option>Belarus</option>
<option>Belgium</option>
<option>Belize</option>
<option>Benin</option>
<option>Bermuda</option>
<option>Bhutan</option>
<option>Bolivia</option>
<option>Bosnia and Herzegovina</option>
<option>Botswana</option>
<option>Bouvet Island</option>
<option>Brazil</option>
<option>British Indian Ocean Territory</option>
<option>Brunei Darussalam</option>
<option>Bulgaria</option>
<option>Burkina Faso</option>
<option>Burundi</option>
<option>Cambodia</option>
<option>Cameroon</option>
<option>Cape Verde</option>
<option>Cayman Islands</option>
<option>Central African Republic</option>
<option>Chad</option>
<option>Chile</option>
<option>China</option>
<option>Christmas Island</option>
<option>Cocos (Keeling) Islands</option>
<option>Colombia</option>
<option>Comoros</option>
<option>Congo</option>
<option>Cook Islands</option>
<option>Costa Rica</option>
<option>Côte d'Ivoire</option>
<option>Croatia</option>
<option>Cuba</option>
<option>Czech Republic</option>
<option>Denmark</option>
<option>Djibouti</option>
<option>Dominica</option>
<option>Dominican Republic</option>
<option>East Timor</option>
<option>Ecuador</option>
<option>Egypt</option>
<option>El salvador</option>
<option>Equatorial Guinea</option>
<option>Eritrea</option>
<option>Estonia</option>
<option>Ethiopia</option>
<option>Falkland Islands</option>
<option>Faroe Islands</option>
<option>Fiji</option>
<option>Finland</option>
<option>France</option>
<option>French Guiana</option>
<option>French Polynesia</option>
<option>French Southern Territories</option>
<option>Gabon</option>
<option>Gambia</option>
<option>Georgia</option>
<option>Ghana</option>
<option>Gibraltar</option>
<option>Greece</option>
<option>Greenland</option>
<option>Grenada</option>
<option>Guadeloupe</option>
<option>Guam</option>
<option>Guatemala</option>
<option>Guinea</option>
<option>Guinea-Bissau</option>
<option>Guyana</option>
<option>Haiti</option>
<option>Heard Island and McDonald Islands</option>
<option>Holy See (Vatican City State)</option>
<option>Honduras</option>
<option>Hungary</option>
<option>Iceland</option>
<option>India</option>
<option>Indonesia</option>
<option>Iran</option>
<option>Iraq</option>
<option>Ireland</option>
<option>Israel</option>
<option>Italy</option>
<option>Jamaica</option>
<option>Japan</option>
<option>Jordan</option>
<option>Kazakstan</option>
<option>Kenya</option>
<option>Kiribati</option>
<option>Kuwait</option>
<option>Kyrgystan</option>
<option>Lao</option>
<option>Latvia</option>
<option>Latvia</option>
<option>Lebanon</option>
<option>Lesotho</option>
<option>Libyan Arab Jamahiriya</option>
<option>Liechtenstein</option>
<option>Lithuania</option>
<option>Luxembourg</option>
<option>Macau</option>
<option>Macedonia (FYR)</option>
<option>Madagascar</option>
<option>Malawi</option>
<option>Malaysia</option>
<option>Maldives</option>
<option>Mali</option>
<option>Malta</option>
<option>Marshall Islands</option>
<option>Martinique</option>
<option>Mauritania</option>
<option>Mauritius</option>
<option>Mayotte</option>
<option>Mexico</option>
<option>Micronesia</option>
<option>Moldova</option>
<option>Monaco</option>
<option>Mongolia</option>
<option>Montserrat</option>
<option>Morocco</option>
<option>Mozambique</option>
<option>Mozambique</option>
<option>Myanmar</option>
<option>Namibia</option>
<option>Nauru</option>
<option>Nepal</option>
<option>Netherlands</option>
<option>Netherlands Antilles</option>
<option>Neutral Zone</option>
<option>New Caledonia</option>
<option>Nicaragua</option>
<option>Niger</option>
<option>Nigeria</option>
<option>Niue</option>
<option>Norfolk Island</option>
<option>North Korea</option>
<option>Northern Mariana Islands</option>
<option>Norway</option>
<option>Oman</option>
<option>Pakistan</option>
<option>Palau</option>
<option>Panama</option>
<option>Papua New Guinea</option>
<option>Paraguay</option>
<option>Peru</option>
<option>Philippines</option>
<option>Pitcairn</option>
<option>Poland</option>
<option>Portugal</option>
<option>Puerto Rico</option>
<option>Reunion</option>
<option>Romania</option>
<option>Russian Federation</option>
<option>Rwanda</option>
<option>Saint Helena</option>
<option>Saint Kitts and Nevis</option>
<option>Saint Lucia</option>
<option>Saint Pierre and Miquelon</option>
<option>Saint Vincent and the Grenadines</option>
<option>Samoa</option>
<option>San Marino</option>
<option>Sao Tome and Principe</option>
<option>Saudi Arabia</option>
<option>Senegal</option>
<option>Seychelles</option>
<option>Sierra Leone</option>
<option>Sierra Leone</option>
<option>Singapore</option>
<option>Slovakia</option>
<option>Slovenia</option>
<option>Solomon Islands</option>
<option>Somalia</option>
<option>South Africa</option>
<option>South Georgia</option>
<option>South Korea</option>
<option>Spain</option>
<option>Sri Lanka</option>
<option>Sudan</option>
<option>Sudan</option>
<option>Suriname</option>
<option>Svalbard and Jan Mayen Islands</option>
<option>Swaziland</option>
<option>Swaziland</option>
<option>Sweden</option>
<option>Switzerland</option>
<option>Switzerland</option>
<option>Syria</option>
<option>Syria</option>
<option>Taiwan</option>
<option>Tajikistan</option>
<option>Tanzania</option>
<option>Thailand</option>
<option>Togo</option>
<option>Tokelau</option>
<option>Tonga</option>
<option>Tonga</option>
<option>Trinidad and Tobago</option>
<option>Tunisia</option>
<option>Turkey</option>
<option>Turkmenistan</option>
<option>Turks and Caicos Islands</option>
<option>Tuvalu</option>
<option>Uganda</option>
<option>Ukraine</option>
<option>United Arab Emirates</option>
<option>Uruguay</option>
<option>Uzbekistan</option>
<option>Vanuatu</option>
<option>Venezuela</option>
<option>Viet Nam</option>
<option>Virgin Islands (British)</option>
<option>Virgin Islands (U.S.)</option>
<option>Wallis and Futuna Islands</option>
<option>Western Sahara</option>
<option>Yemen</option>
<option>Yugoslavia</option>
<option>Zaire</option>
<option>Zambia</option>
<option>Zimbabwe</option>
</select>
</p>
<p>Webhosting gegevens : </p>
<p>Webhosting:
<label>
<select name="webhosting" id="webhosting">
<option>Web Mini</option>
<option>Web Starter</option>
<option>Web Small Business</option>
<option>Web Medium Business</option>
<option>Web Big Business</option>
<option>Web Pro</option>
</select>
</label>
</p>
<p>Domeinaam:
<label>
<input type="text" name="domein" id="domein" />
</label>
</p>
<p>Opties :<span class="style2">:::::::::
<label> </label>
</span>
<label>
<select name="domeinoptie" id="domeinoptie">
<option>Registreer mijn domein</option>
<option>Verhuis mijn domein </option>
<option>Domein niet Registeren</option>
</select>
</label>
</p>
<p>Betaling met
<label>
<select name="betaling" id="betaling">
<option>Paypal</option>
<option>Bank overschrijving</option>
</select>
</label>
</p>
<p><label></label></p>
<p><br />
<input type="submit" name="verzenden" value="Plaats bestelling">
</p>
</form>
<?
}
?>
knop om je tekst aan te passen.