updating values in a while statement

[Anon]

Hiya i've got a script that basically draws values from a db and will display them, as i have multiple records in there and want to display them all i'm using a
while ( ($myrow = mysql_fetch_array($result) ) ) statement this is all good as far as it will display them all how ever when i to be able to update the fields as well as display them .. sounds easy to do i know .. but for some reason my id value gets sent to the server as "id=++" can some one offer any suggestions as to why this is as when i view the source it lists the vaules as 1 2 3 etc.

Thanks
Peter

[Anon]

if you want to increment a variable you should use

$id++;

Hope this is what you want.

[Anon]

Perhaps you could post the smallest trimmed-down minimal version of the source code that still exhibits the problem; that would make it easier to give advice.

[Anon]

<snip>
$rs = "UPDATE main SET system='$system',";
$rs .= "part='$part',";
$rs .= "monthly='$monthly',";
$rs .= "WHERE id=$id";

$result = mysql_query($rs,$db);
?>
<form name="update" method="get" action="../../ben.php">
<?
$foo = "SELECT * FROM main";

$result = mysql_query($foo);
while ( ($myrow = mysql_fetch_array($result,$db) ) ) {

$id = $myrow["id"];
$system = $myrow["system"];
$part = $myrow["part"];
$config = $myrow["monthly"];

?>
<!--form elements with echo on $myrow, and id hidden-->
<?
}
?>
<input type="submit" name="submit" value="Submit">