Deleted a query on update

[Paragon]

Ok this is what happens. I click edit. Then it puts the info into the text boxes. Then I can click modify and it modifys it but it also doubles the 2nd row and deletes the first. I just need some help on finding out why. It also doubles the last row in the MYSQL db.

<?
require "config.php";

   $table = "Ranks";

$connection = mysql_connect($dbhost, $dbusername, $dbpassword);
   mysql_select_db($dbname) or die(mysql_error());


   $Rank = $_POST['Rank'];
   $INFO = $_POST['INFO'];
   $Rnum = $_POST['Rnum'];

   echo "<form name=\"RanksEdit\" method=\"post\" action=\"$PHP_SELF\">";

   if ($Submit == "Add")
	{


   if ($ahead == "+")
		{
			$Add = "INSERT INTO $table VALUES('','$Rank','$INFO','$Rnum')";
            mysql_query($Add) or die(mysql_error());
		}
		else
		{
			$Add = "INSERT INTO $table VALUES('','$Rank','$INFO','$Rnum')";
            mysql_query($Add) or die(mysql_error());
			}

	$action = "";
}
elseif ($Submit == "Modify")
{  

	$idedit = $_POST['ID']; 
	   $Update = "UPDATE $table SET Rank='$Rank', INFO=trim('$INFO'), Rnum='$Rnum' WHERE ID='$idedit'";
       mysql_query($Update) or die(mysql_error());	       
	  $action = "";
	   }


// Delete News
if ($action=="delete")
{
	$Delete = "DELETE FROM $table WHERE ID='$id'";
	mysql_query($Delete) or die(mysql_error());
}

if ($id != "")
{
	// Show selected news
	$Show = mysql_db_query($dbname, "SELECT * FROM $table WHERE ID='$id'");
	$ShowRow = mysql_fetch_array($Show);
	$ShowRank = strip_tags($ShowRow["Rank"]);
	$ShowINFO = strip_tags($ShowRow["INFO"]);
	$ShowRnum = strip_tags($ShowRow["Rnum"]);
	mysql_free_result($Show);
}

// Show all news
$result = mysql_db_query($dbname, "SELECT * FROM $table ORDER BY Rnum");
$row = mysql_fetch_array($result);

if ($action=="edit") 
		{
echo "<input type=\"text\" name=\"Rank\" value=$ShowRank size=\"20\">";
		}
		else
	{
		echo "<input type=\"text\" name=\"Rank\" size=\"20\">";
	}
	echo "<br>";

	echo "<textarea name=\"INFO\" cols=\"45\" rows=\"12\" wrap=\"VIRTUAL\">";
if ($action=="edit") 
		{			
print trim($ShowINFO); 
		}
		print "</textarea>";
		echo "<br>";

	if ($action=="edit") 
		{
echo "<input type=\"text\" name=\"Rnum\" value=$ShowRnum size=\"20\">";
		}
		else
	{
		echo "<input type=\"text\" name=\"Rnum\" size=\"20\">";
	}

	echo "<br>";

if ($action!="edit")
			{
			  	print "<input type=\"submit\" name=\"Submit\" value=\"Add\">";
			}
			else
			{
				echo "<input type=\"hidden\" name=\"ID\" value=".$row["ID"]." size=\"20\">";
			  	print "<input type=\"submit\" name=\"Submit\" value=\"Modify\">";

		}
		echo "<input type=\"button\" value=\"Reset\" onClick=\"location.href = 'RankEdit.php'\">";
		echo "</form>";


		while ($id=$row["ID"])
{

	$id = $row["ID"];
	$Rank = $row["Rank"];
	$INFO = $row["INFO"];   
	$Rnum = $row["Rnum"];

  print "<font size=\"1\" face=\"Verdana, Arial, Helvetica, sans-serif\">";
  print "		$Rank</font><BR>";
  print "<font face=\"Verdana, Arial, Helvetica, sans-serif\" size=\"1\">";	
  print "	Rank Level	$Rnum</font><BR>";
  print "<font face=\"Verdana, Arial, Helvetica, sans-serif\" size=\"1\">";	
  print "	Rank Info :: $INFO</font><BR>";
  print "<font face=\"Verdana, Arial, Helvetica, sans-serif\" size=\"2\">";
  print "		<a href=\"RankEdit.php?id=$id&action=edit\">Edit</a>&nbsp;";
  print "		<a href=\"RankEdit.php?id=$id&action=delete\">Delete</a></font><BR><BR>";

	$row = mysql_fetch_array($result);

}
mysql_free_result ($result);
?>

[HalfaBee]

Here is a problem line

while ($id=$row["ID"])

should be ==

HalfaBee

[HalfaBee]

Also where is $ahead defined?

[Paragon]

In the config. For some reason my Database is putting the send row before the first.

I have it set on auto increment. so its setting 2 in front of 1.

for example

2
1
3
4
5
6

I have no idea why so a little help would be sweet.

[HalfaBee]

Is Rnum the auto inc column?

[Paragon]

no ID is.

it goes.

ID
Rank
Rnum

[Paragon]

problem not fixed

[HalfaBee]

Good

HalfaBee

[Paragon]

I could still use some help please. I have no idea what the heck is wrong.

[HalfaBee]

What problem are you having now?

halfabee

[Paragon]

haha same one. I was wrong the problem wasnt fixed. I just edited the last row and that doesnt have an affect with the above problems.

There are 2 inputs 1 select and then the submit button.

Then there is the mysql row information.

then a edit link and a delete link.

Lets say I have 4 entries in my mysql db I edit the 3rd entry the first entry turns to the information I entered into the inputs the first one is just replaced with the entry.

Thats pretty much it.

[Paragon]

any ideas at all ?