Forum Moderators: coopster
"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 '-mail, country, website, comment) VALUES ('Jeremy', NULL, NULL,"
Here's the code. Sorry it's so long:
<?php require_once('Connections/connGuestbook.php');?>
<?php
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
$theValue = (!get_magic_quotes_gpc())? addslashes($theValue) : $theValue;
switch ($theType) {
case "text":
$theValue = ($theValue!= "")? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue!= "")? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue!= "")? "'" . doubleval($theValue) . "'" : "NULL";
break;
case "date":
$theValue = ($theValue!= "")? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue!= "")? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
$editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}
if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "add_entry")) {
$insertSQL = sprintf("INSERT INTO tblguestbook (name, e-mail, country, website, comment) VALUES (%s, %s, %s, %s, %s)",
GetSQLValueString($_POST['name'], "text"),
GetSQLValueString($_POST['e-mail'], "text"),
GetSQLValueString($_POST['country'], "text"),
GetSQLValueString($_POST['website'], "text"),
GetSQLValueString($_POST['comment'], "text"));
mysql_select_db($database_connGuestbook, $connGuestbook);
$Result1 = mysql_query($insertSQL, $connGuestbook) or die(mysql_error());
$insertGoTo = "guestbook.php";
if (isset($_SERVER['QUERY_STRING'])) {
$insertGoTo .= (strpos($insertGoTo, '?'))? "&" : "?";
$insertGoTo .= $_SERVER['QUERY_STRING'];
}
header(sprintf("Location: %s", $insertGoTo));
}
mysql_select_db($database_connGuestbook, $connGuestbook);
$query_rsGuestbook = "SELECT * FROM tblguestbook ORDER BY id DESC";
$rsGuestbook = mysql_query($query_rsGuestbook, $connGuestbook) or die(mysql_error());
$row_rsGuestbook = mysql_fetch_assoc($rsGuestbook);
$totalRows_rsGuestbook = mysql_num_rows($rsGuestbook);
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Untitled Document</title>
</head>
<body>
<p>Guestbook</p>
<p>Sign our Guestbook</p>
<form action="<?php echo $editFormAction;?>" method="POST" name="add_entry" id="add_entry">
<table width="80%" border="0">
<tr>
<td>Name</td>
<td><label>
<input name="name" type="text" id="name">
</label></td>
</tr>
<tr>
<td>E-mail</td>
<td><label>
<input name="e-mail" type="text" id="e-mail">
</label></td>
</tr>
<tr>
<td>Country</td>
<td> <select name="country">
<option selected value="">Choose a Country
<option value="USA">United States of America
<option value="CAN">Canada
<option value="DEU">Germany
<option value="FRA">France
<option value="GBR">United Kingdom
<option value="IND">India
<option value="">---------------------
<option value="AFG">Afghanistan
<option value="ALB">Albania
<option value="DZA">Algeria
<option value="ASM">American Samoa
<option value="AND">Andorra
<option value="AGO">Angola
<option value="AIA">Anguilla
<option value="ATA">Antarctica
<option value="ATG">Antigua and Barbuda
<option value="ARG">Argentina
<option value="ARM">Armenia
<option value="ABW">Aruba
<option value="AUS">Australia
<option value="AUT">Austria
<option value="AZE">Azerbaijan
<option value="BHS">Bahamas
<option value="BHR">Bahrain
<option value="BGD">Bangladesh
<option value="BRB">Barbados
<option value="BLR">Belarus
<option value="BEL">Belgium
<option value="BLZ">Belize
<option value="BEN">Benin
<option value="BMU">Bermuda
<option value="BTN">Bhutan
<option value="BOL">Bolivia
<option value="BIH">Bosnia and Herzegowina
<option value="BWA">Botswana
<option value="BVT">Bouvet Island
<option value="BRA">Brazil
<option value="IOT">British Indian Ocean Territory
<option value="BRN">Brunei Darussalam
<option value="BGR">Bulgaria
<option value="BFA">Burkina Faso
<option value="BDI">Burundi
<option value="KHM">Cambodia
<option value="CMR">Cameroon
<option value="CPV">Cape Verde
<option value="CYM">Cayman Islands
<option value="CAF">Central African Republic
<option value="TCD">Chad
<option value="CHL">Chile
<option value="CHN">China
<option value="CXR">Christmas Island
<option value="CCK">Cocoa (Keeling) Islands
<option value="COL">Colombia
<option value="COM">Comoros
<option value="COG">Congo
<option value="COK">Cook Islands
<option value="CRI">Costa Rica
<option value="CIV">Cote Divoire
<option value="HRV">Croatia (local name: Hrvatska)
<option value="CUB">Cuba
<option value="CYP">Cyprus
<option value="CZE">Czech Republic
<option value="DNK">Denmark
<option value="DJI">Djibouti
<option value="DMA">Dominica
<option value="DOM">Dominican Republic
<option value="TMP">East Timor
<option value="ECU">Ecuador
<option value="EGY">Egypt
<option value="SLV">El Salvador
<option value="GNQ">Equatorial Guinea
<option value="ERI">Eritrea
<option value="EST">Estonia
<option value="ETH">Ethiopia
<option value="FLK">Falkland Islands (Malvinas)
<option value="FRO">Faroe Islands
<option value="FJI">Fiji
<option value="FIN">Finland
<option value="FXX">France, Metropolitan
<option value="GUF">French Guiana
<option value="PYF">French Polynesia
<option value="ATF">French Southern Territories
<option value="GAB">Gabon
<option value="GMB">Gambia
<option value="GEO">Georgia
<option value="GHA">Ghana
<option value="GIB">Gibraltar
<option value="GRC">Greece
<option value="GRL">Greenland
<option value="GRD">Grenada
<option value="GLP">>Guadeloupe
<option value="GUM">Guam
<option value="GTM">Guatemala
<option value="GIN">Guinea
<option value="GNB">Guinea-Bissau
<option value="GUY">Guyana
<option value="HTI">Haiti
<option value="HMD">Heard and Mc Donald Islands
<option value="HND">Honduras
<option value="HKG">Hong Kong
<option value="HUN">Hungary
<option value="ISL">Iceland
<option value="IDN">Indonesia
<option value="IRN">Iran (Islamic Republic of)
<option value="IRQ">Iraq
<option value="IRL">Ireland
<option value="ISR">Israel
<option value="ITA">Italy
<option value="JAM">Jamaica
<option value="JPN">Japan
<option value="JOR">Jordan
<option value="KAZ">Kazakhstan
<option value="KEN">Kenya
<option value="KIR">Kiribati
<option value="PRK">Korea, Democratic Peoples Republic of
<option value="KOR">Korea, Republic of
<option value="KWT">Kuwait
<option value="KGZ">Kyrgyzstan
<option value="LAO">Lao Peoples Democratic Republic
<option value="LVA">Latvia
<option value="LBN">Lebanon
<option value="LSO">Lesotho
<option value="LBR">Liberia
<option value="LBY">Libyan Arab Jamahiriya
<option value="LIE">Liechtenstein
<option value="LTU">Lithuania
<option value="LUX">Luxembourg
<option value="MAC">Macau
<option value="MKD">Macedonia, The Former Yugoslav Republic of
<option value="MDG">Madagascar
<option value="MWI">Malawi
<option value="MYS">Malaysia
<option value="MDV">Maldives
<option value="MLI">Mali
<option value="MLT">Malta
<option value="MHL">Marshall Islands
<option value="MTQ">Martinique
<option value="MRT">Mauritania
<option value="MVS">Mauritius
<option value="MYT">Mayotte
<option value="MEX">Mexico
<option value="FSM">Micronesia, Federated States of
<option value="MDA">Moldova, Republic of
<option value="MCO">Monaco
<option value="MNG">Mongolia
<option value="MSR">Montserrat
<option value="MAR">Morocco
<option value="MOZ">Mozambique
<option value="MMR">Myanmar
<option value="NAM">Namibia
<option value="NRU">Nauru
<option value="NPL">Nepal
<option value="NLD">Netherlands
<option value="ANT">Netherlands Antilles
<option value="NCL">New Caledonia
<option value="NZL">New Zealand
<option value="NIC">Nicaragua
<option value="NER">Niger
<option value="NGA">Nigeria
<option value="NIU">Niue
<option value="NFK">Norfolk Island
<option value="MNP">Northern Mariana Islands
<option value="MOR">Norway
<option value="OMN">Oman
<option value="PAK">Pakistan
<option value="PLW">Palau
<option value="PAN">Panama
<option value="PNG">Papua New Guinea
<option value="PRY">Paraguay
<option value="PER">Peru
<option value="PHL">Philippines
<option value="PCN">Pitcairn
<option value="POL">Poland
<option value="PRT">Portugal
<option value="PRI">Puerto Rico
<option value="QAT">Qatar
<option value="REU">Reunion
<option value="ROM">Romania
<option value="RUS">Russian Federation
<option value="RWA">Rwanda
<option value="KNA">Saint Kitts and Nevis
<option value="LCA">Saint Lucia
<option value="VCT">Saint Vincent and the Grenadines
<option value="WSM">Samoa
<option value="SMR">San Marino
<option value="STP">Sao Tome and Principe
<option value="SAU">Saudi Arabia
<option value="SEN">Senegal
<option value="SYC">Seychelles
<option value="SLE">Sierra Leone
<option value="SGP">Singapore
<option value="SVK">Slovakia (Slovak Republic)
<option value="SVN">Slovenia
<option value="SLB">Solomon Islands
<option value="SOM">Somalia
<option value="ZAF">South Africa
<option value="SGS">South Georgia and the South Sandwich Islands
<option value="ESP">Spain
<option value="LKA">Sri Lanka
<option value="SHN">St. Helena
<option value="SPM">St. Pierre and Miquelon
<option value="SDN">Sudan
<option value="SUR">Suriname
<option value="SJM">Svalbard and Jan Mayen Islands
<option value="SWZ">Swaziland
<option value="SWE">Sweden
<option value="CHE">Switzerland
<option value="SYR">Syrian Arab Republic
<option value="TWN">Taiwan
<option value="TJK">Tajikistan
<option value="TZA">Tanzania, United Republic of
<option value="THA">Thailand
<option value="TGO">Togo
<option value="TKL">Tokelau
<option value="TON">Tonga
<option value="TTO">Trinidad and Tobago
<option value="TUN">Tunisia
<option value="TUR">Turkey
<option value="TKM">Turkmenistan
<option value="TCA">Turks and Caicos Islands
<option value="TUV">Tuvalu
<option value="UGA">Uganda
<option value="UKR">Ukraine
<option value="ARE">United Arab Emirates
<option value="UMI">United States Minor Outlying Islands
<option value="URY">Uruguay
<option value="UZB">Uzbekistan
<option value="VUT">Vanuatu
<option value="VAT">Vatican City State (Holy See)
<option value="VEN">Venezuela
<option value="VNM">Viet Nam
<option value="VGB">Virgin Islands (British)
<option value="VIR">Virgin Islands (U.S.)
<option value="WLF">Wallisw and Futuna Islands
<option value="ESH">Western Sahara
<option value="YEM">Yeman
<option value="YUG">Yugoslavia
<option value="ZAR">Zaire
<option value="ZMB">Zambia
<option value="ZWE">Zimbabwe
<option value="UNK">Not Listed
</select></td>
</tr>
<tr>
<td>Website</td>
<td><label>
<input name="website" type="text" id="website">
</label></td>
</tr>
<tr>
<td>Comment</td>
<td><label>
<textarea name="comment" id="comment"></textarea>
</label></td>
</tr>
<tr>
<td> </td>
<td><label>
<input type="submit" name="Submit" value="Submit">
</label></td>
</tr>
</table>
<input type="hidden" name="MM_insert" value="add_entry">
</form>
<p> </p>
</body>
</html>
<?php
mysql_free_result($rsGuestbook);
?>
$insertSQL = sprintf("INSERT INTO tblguestbook (name, `e-mail`, country, website, comment)
