For some reason not overwriting database recordset

[jamesojackson]

for some reason, my recordset updating is not working.. any help would be appreciated!

<?php 

session_start();
if ($_SESSION['membersarea']!="Active") {
	echo "<script>document.location.href='login.php'</script>";
} else {

include_once ("config/config.php");

include ("themes/header.php");

$aucid=$_REQUEST['aucofferid'];
$override= "SELECT * FROM house_offers WHERE auctionid='$aucid'";
$oresult= mysql_query($override);
$count = mysql_num_rows($oresult);

?>
<table width="500" border="0" cellspacing="1" cellpadding="0">
<form name="form1" method="post" action="">
<tr>
<td>
<table width="500" border="0" cellspacing="1" cellpadding="0">


<tr>
<td align="center"><strong>Id</strong></td>
<td align="center"><strong>Amount</strong></td>
</tr>
<?php
while($rows=mysql_fetch_array($oresult)){
?>
<tr>
<td align="center"><? $id[]=$rows['buyerid']; ?><? echo $rows['buyerid']; ?></td>
<td align="center"><input name="amount[]" type="text" id="amount" value="<? echo $rows['amount']; ?>"></td>
</tr>
<?php
}
?>
<tr>
<td colspan="4" align="center"><input type="submit" name="Submit" value="Submit"></td>
</tr>
</table>
</td>
</tr>
</form>
</table>
<?php
// Check if button name "Submit" is active, do this
if (isset($Submit)){
for($i=0;$i<$count;$i++){
$sql1="UPDATE house_offers SET amount='$amount[$i]' WHERE buyerid='$buyerid[$i]'";
$result1=mysql_query($sql1);
}
}

if($result1){
header("location:updateoffers.php");
}
}
?>

[Kudose]

You are assuming register_globals is On.

Try

if(isset($_POST['Submit'])){

[jamesojackson]

tried recommended change... but no luck...
racking my brain... can't figure out the problem..
thanks again for your help

[cgraz]

What does "not working" mean? Errors, blank page, undefined variables...?

Print your SQL query strings and use mysql_error() if it's a MySQL issue. ie

$override= "SELECT * FROM house_offers WHERE auctionid='$aucid'";
print 'Query: ' . $override . '<br />';
$oresult = mysql_query($override) or die( mysql_error() );