I'm new to this stuff and I have an html table which displays information from a mysql database, that part seems to be working fine. The idea of the table is to allow the information to be edited and then saved back to the database and that's where I'm stuck. If I add/edit some information in the table and then click on submit, the page refreshes, the table fields are now empty, and nothing has changed in the database. Can someone give me some clues as to where I'm going wrong? I'm not asking anyone to write my code for me, just hopefully get me a little further along than I am, thanks.
<html>
<head><title>Edit Southware Customer Information</title></head>
<body>
<?php
$cust=$_POST['list1'];
//echo "cust: $cust";
// connect to db
$conn = mysql_connect('localhost','root') or trigger_error("SQL", E_USER_ERROR);
$db = mysql_select_db('sw_customers',$conn) or trigger_error("SQL", E_USER_ERROR);
$sql = "select custName, contact, address1, address2, address3, city, state, zipcode, Phone, Fax, contractNum, rev, userCount,
productCode, productKey, serialNum, custAuth, prodAuth, licenseNum, installPath from customer_info where custName like '$cust'";
$result = mysql_query($sql, $conn) or trigger_error("SQL", E_USER_ERROR);
$row = mysql_fetch_assoc($result);
echo "<form action= '{$_SERVER['PHP_SELF']}' method=post>";
echo "<table border=1, cellpadding=1, cellspacing=1>";
// echo "row: $row[custName]<br/>";
echo "<tr><td width=200 font size=7><font face=Tahoma>Customer Name</td><td width=400><input type=text style='width:400px; font-family:Tahoma; font-size:16' name=custName value='$row[custName]'></td></tr>";
echo "<tr><td font size=7><font face=Tahoma>Contact</td><td width=400><input type=text style='width:400px; font-family:Tahoma; font-size:16' name=contact value='$row[contact]'></td></tr>";
echo "<tr><td font size=7><font face=Tahoma>Address Line 1</td><td width=400><input type=text style='width:400px; font-family:Tahoma; font-size:16' name=address1 value='$row[address1]'></td></tr>";
echo "<tr><td font size=7><font face=Tahoma>Address Line 2</td><td width=400><input type=text style='width:400px; font-family:Tahoma; font-size:16' name=address2 value='$row[address2]'></td></tr>";
echo "<tr><td font size=7><font face=Tahoma>Address Line 3</td><td width=400><input type=text style='width:400px; font-family:Tahoma; font-size:16' name=address3 value='$row[address3]'></td></tr>";
echo "<tr><td font size=7><font face=Tahoma>City</td><td width=400><input type=text style='width:400px; font-family:Tahoma; font-size:16' name=city value='$row[city]'></td></tr>";
echo "<tr><td font size=7><font face=Tahoma>State</td><td width=400><input type=text style='width:400px; font-family:Tahoma; font-size:16' name=state value='$row[state]'></td></tr>";
echo "<tr><td font size=7><font face=Tahoma>Zipcode</td><td width=400><input type=text style='width:400px; font-family:Tahoma; font-size:16' name=zipcode value='$row[zipcode]'></td></tr>";
echo "<tr><td font size=7><font face=Tahoma>Phone Number</td><td width=400><input type=text style='width:400px; font-family:Tahoma; font-size:16' name=phone value='$row[phone]'></td></tr>";
echo "<tr><td font size=7><font face=Tahoma>Fax Number</td><td width=400><input type=text style='width:400px; font-family:Tahoma; font-size:16' name=fax value='$row[fax]'></td></tr>";
echo "<tr><td font size=7><font face=Tahoma>Contract Number</td><td width=400><input type=text style='width:400px; font-family:Tahoma; font-size:16' name=contractNum value='$row[contractNum]'></td></tr>";
echo "<tr><td font size=7><font face=Tahoma>Revision</td><td width=400><input type=text style='width:400px; font-family:Tahoma; font-size:16' name=rev value='$row[rev]'></td></tr>";
echo "<tr><td font size=7><font face=Tahoma>User Count</td><td width=400><input type=text style='width:400px; font-family:Tahoma; font-size:16' name=userCount value='$row[userCount]'></td></tr>";
echo "<tr><td font size=7><font face=Tahoma>Product Code</td><td width=400><input type=text style='width:400px; font-family:Tahoma; font-size:16' name=productCode value='$row[productCode]'></td></tr>";
echo "<tr><td font size=7><font face=Tahoma>Product Key</td><td width=400><input type=text style='width:400px; font-family:Tahoma; font-size:16' name=productKey value='$row[productKey]'></td></tr>";
echo "<tr><td font size=7><font face=Tahoma>Serial Number</td><td width=400><input type=text style='width:400px; font-family:Tahoma; font-size:16' name=serialNum value='$row[serialNum]'></td></tr>";
echo "<tr><td font size=7><font face=Tahoma>Customer Authorization</td><td width=400><input type=text style='width:400px; font-family:Tahoma; font-size:16' name=custAuth value='$row[custAuth]'></td></tr>";
echo "<tr><td font size=7><font face=Tahoma>Product Authorization</td><td width=400><input type=text style='width:400px; font-family:Tahoma; font-size:16' name=prodAuth value='$row[prodAuth]'></td></tr>";
echo "<tr><td font size=7><font face=Tahoma>License Number</td><td width=400><input type=text style='width:400px; font-family:Tahoma; font-size:16' name=licenseNum value='$row[licenseNum]'></td></tr>";
echo "<tr><td font size=7><font face=Tahoma>Install Path</td><td width=400><input type=text style='width:400px; font-family:Tahoma; font-size:16' name=installPath value='$row[installPath]'></td></tr>";
echo "</table>";
echo "</br>";
echo "<input type=submit style='height:40px; width:150px' name=editCust value='Submit Changes'>";
?>
<?php
if(isset($_POST['submit'])) {
echo $row[custName];
echo $row[city];
update();
}
?>
<?php
function update() {
$custName=$_POST['custName'];
$contact=$_POST['contact'];
$address1=$_POST['address1'];
$address2=$_POST['address2'];
$address3=$_POST['address3'];
$city=$_POST['city'];
$state=$_POST['state'];
$zipcode=$_POST['zipcode'];
$phone=$_POST['phone'];
$fax=$_POST['fax'];
$contractNum=$_POST['contractNum'];
$rev=$_POST['rev'];
$userCount=$_POST['userCount'];
$productCode=$_POST['productCode'];
$productKey=$_POST['productKey'];
$serialNum=$_POST['serialNum'];
$custAuth=$_POST['custAuth'];
$prodAuth=$_POST['prodAuth'];
$licenseNum=$_POST['licenseNum'];
$installpath=$_POST['installPath'];
$sql = "UPDATE customer_info SET custName='$custName', contact='$contact',
address1='$address1', address2='$address2', address3='$address3', city='$city', state='$state', zipcode='$zipcode',
phone='$phone', fax='$fax', contractNum='$contractNum', rev='$rev', userCount='$userCount', productCode='$productCode',
productKey='$productKey', serialNum='$serialNum', custAuth='$custAuth', prodAuth='$prodAuth', licenseNum='$licenseNum',
installPath='$installPath' WHERE custNum = 1011 LIMIT 1";
mysql_query($sql, $conn);
}
?>
</form>
</body>
</html>
