save $orderid under the right $id

[IamHS]

I have been working on this for a while now.
and i'm trying to save the $orderid to the right $id but i does just not work proberly.
i don't really understand why i doesn't, maybe it's because i'm a newb. 😃

if any one knows what i'm doing wrong, and are willing to kindly guide me on the right track. i will be most happy.

if ($submit) {

$sql = "UPDATE db01 SET orderid='$orderid' WHERE id=$id";

$result = mysql_query($sql);

echo "Updated!<p>";

} elseif ($delete) {

$sql = "DELETE FROM db01 WHERE id=$id";	

$result = mysql_query($sql);

echo "Deleted!<p>";

} elseif ($sortorderid) {

$result = mysql_query("select * from db01 ORDER BY orderid", $connection);	
while ($myrow = mysql_fetch_array($result)) {

  printf("[ Name : %s ]\n", $myrow["name"]);
  printf("[ ID : %s ]\n", $myrow["id"]);
  printf("[ <a href=\"%s?id=%s&sortorderid=yes\">orderID :</a> <input class='inputord' type=\"Text\" name=\"orderid\" value=\"%s\"> ]\n", $PHP_SELF, $myrow["id"], $myrow["orderid"]);
  printf("[ <a href=\"%s?id=%s&delete=yes\">SLET</a> ]<br>\n", $PHP_SELF, $myrow["id"]);	

  }

printf("<input class='inputbtn' type='Submit' name='submit' value='Gem orderID'></form>");

}

sorry for my bad english

[tbach2]

any error messages?

is the database being updated?

are you ever inserting instead of updating (if the record doesn't exist, you can't update it)?

Are you sure the variables are actually being passed to the script (try printing out the variables)?

[IamHS]

any error messages?

• no

is the database being updated?

Yes the database gets updated, but every $id gets the same $orderid ( actually think i forgot to mention that )

are you ever inserting instead of updating (if the record doesn't exist, you can't update it)?

• yes, but not here. the record are there already, it is reguired of you to fill it out in the first place otherwise there will come an box telling you to do it.

Are you sure the variables are actually being passed to the script (try printing out the variables)?

yes, it workz the same data just ends up in the wrong records