2 problems:
I deleted a row, and the auto_increment primary key needs to be reset. i.e. so the next primary key is the last number +1. (is there a delete statement that does this?)
Some fields in my form are completed using a preset drop down box. However these fields are the only fields that are not inserted into the database.
The fields are Industry, ClientStType, ClientCityName and ClientCountry.
HERE IS THE FORM:
<form action="http://localhost/insert_client.php" method="post">
<table border=0 font-size=8>
<tr><td><font=8>Industry</font></td><td>
<select name="searchtype">
<option value="Banking">Banking
<option value="Commerce">Commerce
<option value="Energy">Energy
<option value="IT">IT
<option value="Media">Media
<option value="Market Data">Market Data
<option value="Project Management">Project Management
</select><br></td></font></tr>
<tr><td>Name</td><td><input type=text name=ClientName maxlength=50 size=30><br></td></tr>
<tr><td>Building</td><td> <input type=text name=ClientBldgName maxlength=20 size=20><br></td></tr>
<td>Number</td><td><input type=text name=ClientStNo maxlength=5 size=5><br></td>
<td>Name</td><td> <input type=text name=ClientStName maxlength=20 size=20><br></td>
<td><font=8>Type</font></td><td>
<select name="searchtype">
<option value="">
<option value="Street">Street
<option value="Road">Road
<option value="Avenue">Avenue
<option value="Boulevard">Boulevard
<option value="Crescent">Crescent
</select><br></td></font>
<td>District</td><td><input type=text name=ClientDistName maxlength=20 size=20><br></td>
<tr><td>City</td><td>
<select name="searchtype">
<option value="London">London
<option value="Birmingham">Birmingham
<option value="Manchester">Liverpool
<option value="Newcastle">Newcastle
<option value="Leeds">Leeds
<option value="Liverpool">Liverpool
<option value="Glasgow">Glasgow
<option value="Edinburgh">Edinburgh
<option value="Paris">Paris
<option value="Madrid">Madrid
<option value="Barcelona">Barcelona
<option value="Amsterdam">Amsterdam
<option value="Brussels">Brussels
<option value="Frankfurt">Frankfurt
<option value="Milan">Milan
<option value="Rome">Rome
<option value="Zurich">Zurich
<option value="Stockholm">Stockholm
<option value="Copenhagen">Copenhagen
<option value="Oslo">Oslo
<option value="Moscow">Moscow
<option value="New York">New York
<option value="Tokyo">Tokyo
<option value="Singapore">Singapore
<option value="Hong Kong">Hong Kong
<option value="Sydney">Sydney
<option value="Auckland">Auckland
</select><br></td></tr>
<tr><td>Post/Zip</td><td><input type=text name=ClientPostCode maxlength=10 size=10><br></td></tr>
<tr><td>Country</td><td>
<select font=2 name="searchtype">
<option value="United Kingdom">United Kingdom
<option value="Rep of Ireland">Rep of Ireland
<option value="France">France
<option value="Spain">Spain
<option value="Netherlands">Netherlands
<option value="Italy">Italy
<option value="Germany">Germany
<option value="Switzerland">Switzerland
<option value="Norway">Norway
<option value="Denmark">Denmark
<option value="Sweden">Sweden
<option value="Italy">Italy
<option value="Germany">Germany
<option value="Switzerland">Switzerland
<option value="Norway">Norway
<option value="Belguim">Belguim
<option value="Russia">Russia
<option value="USA">USA
<option value="Singapore">Singapore
<option value="China">China
<option value="Malaysia">Malaysia
<option value="Australia">Australia
<option value="New Zealand">New Zealand
AND HERE IS THE RESULTS.PHP PAGE:
<head>
<title>4i dotCom Entry Results</title>
</head>
<body>
<h1>4i dotCom Entry Results</h1>
<?
if (!$ClientName || !$ClientStNo || !$ClientStName || !$ClientPostCode || !$AreaCode || !$MainPhone || !$MainFax || !$MainEmail || !$MainContact || !$ConsultantID)
{
echo "You have not entered all the required details.<br>"
."Please go back and try again.";
exit;
}
$ClientID = addslashes($ClientID);
$ClientName = addslashes($ClientName);
$ClientBldgName = addslashes($ClientBldgName);
$ClientStNo = addslashes($ClientStNo);
$ClientStName = addslashes($ClientStName);
$ClientStType = addslashes($ClientStType);
$ClientDistName = addslashes($ClientDistName);
$ClientCityName = addslashes($ClientCityName);
$ClientPostCode = addslashes($ClientPostCode);
$ClientCountry = addslashes($ClientCountry);
$AreaCode = addslashes($AreaCode);
$MainPhone = doubleval($MainPhone);
$MainFax = doubleval($MainFax);
$MainEmail = addslashes($MainEmail);
$MainContact = addslashes($MainContact);
$Comments = addslashes($Comments);
$MainContact = addslashes($MainContact);
$ConsultantID = doubleval($ConsultantID);
$db = @mysql_pconnect("localhost.localdomain:3306", "root", "password");
if (!$db)
{
echo "Error: Could not connect to database. Please try again later.";
exit;
}
mysql_select_db("4i_dotCom");
$query = "insert into Clients (ClientID, ClientName, ClientBldgName, ClientStNo, ClientStName,
ClientDistName, ClientCityName, ClientPostCode, ClientCountry, Industry, AreaCode, MainPhone, MainFax,
MainEmail, MainContact, Comments, ConsultantID, ClientStType) values
('".ClientID."', '".$ClientName."', '".$ClientBldgName."', '".$ClientStNo."', '".$ClientStName."',
'".$ClientDistName."', '".$ClientCityName."', '".$ClientPostCode."', '".$ClientCountry."',
'".$Industry."', '".$AreaCode."', '".$MainPhone."', '".$MainFax."', '".$MainEmail."', '".$MainContact."', '".$Comments."', '".$ConsultantID."', '".ClientStType."')";
$result = mysql_query($query) or die("Error: ".mysql_error());
if ($result)
echo mysql_affected_rows()." client inserted into database.";
?>
</body>
Any ideas?
