Insert page returns error 'Duplicate entry '0' for key 'PRIMARY'' Reload this Page
see code for Insert page below:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>Insert usedbikes</title>
<link href="WA_DataAssist/styles/Refined_Pacifica.css" rel="stylesheet" type="text/css" />
<link href="WA_DataAssist/styles/Arial.css" rel="stylesheet" type="text/css" />
</head>
<body>
<div class="WADAInsertContainer">
<form action="usedbikes_Insert.php" method="post" name="WADAInsertForm" id="WADAInsertForm">
<div class="WADAHeader">GP Motorcycles Major Unit Inventory: Insert Bike Details</div>
<div class="WADAHorizLine"><img src="WA_DataAssist/images/_tx_.gif" alt="" height="1" width="1" border="0" /></div>
<table class="WADADataTable" cellpadding="0" cellspacing="0" border="0">
<tr>
<th class="WADADataTableHeader">New or Used:</th>
<td class="WADADataTableCell"><table>
<tr>
<td width="72"><input type="radio" name="new_or_used" value="New" />
New</td>
</tr>
<tr>
<td><input type="radio" name="new_or_used" value="Used" />
Used</td>
</tr>
</table></td>
</tr>
<tr>
<th class="WADADataTableHeader">Model Year:</th>
<td class="WADADataTableCell"><input type="text" name="modelyear" id="modelyear" value="" size="32" /></td>
</tr>
<tr>
<th class="WADADataTableHeader">Make:</th>
<td class="WADADataTableCell"><input type="text" name="make" id="make" value="" size="32" /></td>
</tr>
<tr>
<th class="WADADataTableHeader">Model:</th>
<td class="WADADataTableCell"><input type="text" name="model" id="model" value="" size="32" /></td>
</tr>
<tr>
<th class="WADADataTableHeader">Description:</th>
<td class="WADADataTableCell"><input type="text" name="description" id="description" value="" size="32" /></td>
</tr>
<tr>
<th class="WADADataTableHeader">Mileage:</th>
<td class="WADADataTableCell"><input type="text" name="mileage" id="mileage" value="" size="32" /></td>
</tr>
<tr>
<th class="WADADataTableHeader">Stock Number:</th>
<td class="WADADataTableCell"><input type="text" name="stocknumber" id="stocknumber" value="" size="32" /></td>
</tr>
<tr>
<th class="WADADataTableHeader">Price:</th>
<td class="WADADataTableCell"><input type="text" name="price" id="price" value="" size="32" /></td>
</tr>
<tr>
<th class="WADADataTableHeader">Status:</th>
<td class="WADADataTableCell"><table>
<tr>
<td width="114"><input type="radio" name="status" value="In Inventory" />
In Inventory</td>
</tr>
<tr>
<td><input type="radio" name="status" value="Sold" />
Sold</td>
</tr>
</table></td>
</tr>
<tr>
<th class="WADADataTableHeader">Image Source URL:</th>
<td class="WADADataTableCell"><input type="text" name="image" id="image" value="" size="32" /></td>
</tr>
</table>
<div class="WADAHorizLine"><img src="WA_DataAssist/images/_tx_.gif" alt="" height="1" width="1" border="0" /></div>
<div class="WADAButtonRow">
<table class="WADADataNavButtons" border="0" cellpadding="0" cellspacing="0">
<tr>
<td class="WADADataNavButtonCell" nowrap="nowrap"><input type="image" name="Insert" id="Insert" value="Insert" alt="Insert" src="WA_DataAssist/images/Pacifica/Refined_insert.gif" /></td>
<td class="WADADataNavButtonCell" nowrap="nowrap"><a href="usedbikes_Results.php" title="Cancel"><img border="0" name="Cancel" id="Cancel" alt="Cancel" src="WA_DataAssist/images/Pacifica/Refined_cancel.gif" /></a></td>
</tr>
</table>
<input name="WADAInsertRecordID" type="hidden" id="WADAInsertRecordID" value="" />
</div>
</form>
</div>
</body>
</html>
