Update Query Issue

[cmaclennan]

Hi Guys,

 

I'm hoping someone can find what I clearly cant see, I have a page meant to update database records, the page will load and populate with the existing data and allow 5 out of the 7 fields to be edited, however when editing any of those 5, the remaining 2 blank out and can't be filled in again. Im at a bit of loss and have been staring at it for a bit too long i think, hoping a fresh set of eyes can help.

 

Here's the page (the fields I'm having issues with are inv1/inv2:

 

<?php

$page_title = 'Edit a Cart';
include ('style.html');

// Check for a valid ID, through GET or POST.
if ( (isset($_GET['id'])) ) { // Accessed through active_search.php
$id = $_GET['id'];
} elseif ( (isset($_POST['id'])) ) { // Form has been submitted.
$id = $_POST['id'];
} else { // No valid ID, kill the script.
echo '<div id="title">Page Error</div>
<p class="error">This page has been accessed in error.</p><p><br /><br /></p>'; 
exit();
}

require_once ('mysql_connect.php'); // Connect to the db.

// Check if the form has been submitted.
if (isset($_POST['submitted'])) {

$errors = array(); // Initialize error array.

// Check for a PO.
{
	$po = trim($_POST['po']);
}

// Check for a Master Serial.
{
	$sr = trim($_POST['serial']);
}

// Check for a Charger Serial.
{
	$ch = trim($_POST['charger']);
}

// Check for a Battery Serial.
{
	$bt1 = trim($_POST['battery1']);
}

// Check for a Battery Serial.
{
	$bt2 = trim($_POST['battery2']);
}

// Check for a Inverter Serial.
{
	$in1 = trim($_POST['inv1']);
}

// Check for a 2nd Inverter Serial.
{
	$in2 = trim($_POST['inv2']);
}

// Check for a Radio Serial.
{
	$abc = trim($_POST['abc']);
}

if (empty($errors)) { // If everything's OK.

	//  Test for unique master serial.
	$query = "SELECT serial FROM serials WHERE serial='$id'";
	$result = mysql_query($query);
	if (mysql_num_rows($result) == 1) {

		// Make the query.
		$query = "UPDATE serials SET po='$po', serial='$sr', charger='$ch', batt1='$bt1', batt2='$bt2', inv1='$in1', inv2='$in2', abc='$abc' WHERE serial='$id'";
		$result = @mysql_query ($query); // Run the query.
		if (mysql_affected_rows() == 1) { // If it ran OK.

			// Print a message.
			echo '<div id="title">Success!</div>
			<p>The node has been edited.<a href="javascript:window.close();">Close</a></p><p><br /><br /></p>';	

		} else { // If it did not run OK.
			echo '<div id="title">System Error</div>
			<p class="error">The node could not be edited due to a system error. We apologize for any inconvenience.</p>'; // Public message.
			echo '<p>' . mysql_error() . '<br /><br />Query: ' . $query . '</p>'; // Debugging message. 
			exit();
		}

	} else { // Already registered.
		echo '<div id="title">Error!</div>
		<p class="error">The Serial has already been registered.</p>';
	}

} else { // Report the errors.

	echo '<div id="title">Error!</div>
	<p class="error">The following error(s) occurred:<br />';
	foreach ($errors as $msg) { // Print each error.
		echo " - $msg<br />\n";
	}
	echo '</p><p>Please try again.</p><p><br /></p>';

} // End of if (empty($errors)) IF.

} // End of submit conditional.

// Always show the form.

// Retrieve the user's information.
$query = "SELECT * FROM serials WHERE serial='$id'";		
$result = @mysql_query ($query); // Run the query.

if (mysql_num_rows($result) == 1) { // Valid ID, show the form.

// Get the user's information.
$row = mysql_fetch_array ($result);

// Create the form.
echo '<div id="title">Edit a Cart</div>
<form action="serial_edit.php" method="post">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>P.O #:</td><td><input type="text" name="po" size="15" maxlength="15" value="' . $row['po'] . '" /></td>
</tr>
<tr>
<td>Cart Serial:</td><td><input type="text" name="serial" size="15" maxlength="30" value="' . $row['serial'] . '" /></td>
</tr>
<tr>
<td>Charger:</td><td><input type="text" name="charger" size="20" maxlength="40" value="' . $row['charger'] . '"  /> </td>
</tr>
<tr>
<td>Battery 1:</td><td><input type="text" name="battery1" size="20" maxlength="40" value="' . $row['batt1'] . '"  /> </td>
</tr>
<tr>
<td>Battery 2:</td><td><input type="text" name="battery2" size="20" maxlength="40" value="' . $row['batt2'] . '"  /> </td>
</tr>
<tr>
<td>Inverter 1:</td><td><input type="text" name="inverter1" size="20" maxlength="40" value="' . $row['inv1'] . '"  /> </td>
</tr>
<tr>
<td>Inverter 2:</td><td><input type="text" name="inverter2" size="20" maxlength="40" value="' . $row['inv2'] . '"  /> </td>
</tr>
<tr>
<td>ABC:</td><td><input type="text" name="abc" size="20" maxlength="40" value="' . $row['abc'] . '"  /> </td>
</tr>
<tr>
<td><input type="submit" name="submit" value="Submit" /><input type="hidden" name="submitted" value="TRUE" /></td>
<td><input type="hidden" name="id" value="' . $id . '" /></td></tr>
</form>';

} else { // Not a valid ID.
echo '<div id="title">Page Error</div>
<p class="error">This page has been accessed in error.</p><p><br /><br /></p>';
}

mysql_close(); // Close the database connection.

?>

[Pikachu2000]

Your form fields are named inverter1 and inverter2, but you're looking for values in $_POST['inv1'] and $_POST['inv2'].

[cmaclennan]

Thanks, I knew I needed a fresh set of eyes. Much appreciated.