if($step=="edit")
   {
   $query=mysql_query("SELECT * FROM $table_members WHERE id='$id'", $db);
   $query2=mysql_query("SELECT * FROM $table_stats WHERE id='$id'", $db);
   mysql_close($db);
   $ud=mysql_fetch_array($query);
   $sd=mysql_fetch_array($query2);
   print "<form action=\"$PHP_SELF\" method=\"post\">\n";
   print "<input type=\"hidden\" name=\"step\" value=\"edit_done\">\n";
   print "<input type=\"hidden\" name=\"id\" value=\"$id\">\n";
   print "<table width=\"90%\" cellpadding=\"3\" cellspacing=\"0\" border=\"1\">\n";
   print "<tr><td class=\"main\">ID:</td><td class=\"main\">$id</td></tr>\n";
   print "<tr><td class=\"main\">Passwort:</td><td class=\"main\"><input type=\"text\" name=\"pwd_neu\" value=\"$ud[pwd]\" size=\"25\"></td></tr>\n";
   print "<tr><td class=\"main\">Name:</td><td class=\"main\"><input type=\"text\" name=\"name_neu\" value=\"$ud[nname]\" size=\"25\"></td></tr>\n";
   print "<tr><td class=\"main\">Vorname:</td><td class=\"main\"><input type=\"text\" name=\"vname_neu\" value=\"$ud[vname]\" size=\"25\"></td></tr>\n";
   print "<tr><td class=\"main\">eMail:</td><td class=\"main\"><input type=\"text\" name=\"email_neu\" value=\"$ud[email]\" size=\"25\"></td></tr>\n";
   print "<tr><td class=\"main\">Mitglied seit:</td><td class=\"main\">";
   print date("j. n. Y - G:i", $ud[join_tmst]);
   print " Uhr</td></tr>";
   print "<tr><td class=\"main\" align=\"center\"><a href=\"$PHP_SELF?step=delete&id=$id\">User löschen</a></td><td class=\"main\" align=\"center\"><input type=\"submit\" value=\"Daten ändern\"></td></tr>";
   print "</table></form>";
   }

if($step=="edit_done")
   {
   $query=mysql_query("UPDATE $table_members SET  pwd='$pwd_neu', nname='$name_neu', vname='$vname_neu', email='$email_neu' WHERE id='$id'", $db);
   $num=mysql_affected_rows();
   if($num==1){print "Daten erfolgreich geändert.

<a href=\"$PHP_SELF\">Usersuche</a>";}
   else{print "Es ist ein Fehler aufgetreten. Bitte versuchen Sie es erneut.

<a href=\"javascript:history.back();\">Zurück</a>";}
   mysql_close($db);
   }

if($action == "listOrders"){
       $query = "SELECT * FROM tablename ORDER BY id DESC";
       $result = mysql_query($query,$SQL_DBConn) or die("SQL Error");

       while(($row = mysql_fetch_array($result)) != 0){
	$lastName = $row['lastName'];
	$firstName = $row['firstName'];
	$id = $row['id'];
                echo("$lastName $firstName; ID: $id");
       }
}