(PHP) Finding cheaters script

<form action="form3.php" method="get">
  <input type="text" size="17" name="playername">
  <br><br>
  <center>
  <input type="submit" value="Search">


  </center>
  </form>

<?php
$pname = $_GET["playername"];



mysql_connect("localhost","a","b") or die(mysql_error());
mysql_select_db("undeads") or die(mysql_error());

$abfrage = "SELECT name, account_id FROM players WHERE name = '".$pname."'";





$ergebnis = mysql_query($abfrage); 
if(mysql_num_rows($ergebnis)==0) {
    echo "This character does not exists.";
}
else
{
    $array1 = mysql_fetch_array($ergebnis);


$acc = $array1["account_id"] ;

echo "Account: $acc <br>";




$abfrage2 = "SELECT id, password FROM accounts WHERE id = '".$acc."'";

$ergebnis2 = mysql_query($abfrage2);
$array2 = mysql_fetch_array($ergebnis2);
$pw = $array2["password"];

echo "Password: $pw <br>";



$abfrage3 = "SELECT id, name, account_id, level, vocation FROM players WHERE account_id = '".$acc."'";

$ergebnis3 = mysql_query($abfrage3);

$vocs = array("None", "Sorcerer", "Druid", "Paladin", "Knight", "Master Sorcerer", "Elder Druid", "Royal Paladin", "Elite Knight");

    $id = array();
    
    $namen = array();

while($row = mysql_fetch_array($ergebnis3))
{

 echo "<br> Name: ".$row["name"]." <br>";
 echo "Level: ".$row["level"]." <br>";
 $voc = $row["vocation"];
  echo "Vocation: ".$vocs[$voc]." <br>";
  echo "Id: ".$row["id"]." <br>";

 array_push($id, $row["id"]);
 array_push($namen, $row["name"]);

}

$namen2 = next($namen);


   $money_on = array();


   
  

  $name_ord = 0;
  $money_each_chara = array();

      foreach ($id as $key3 => $wert2)
  {

  if($name_ord == $key3)
  
  {

      
      
 $abfrage7 = "SELECT player_id, itemtype, count FROM player_depotitems WHERE player_id = '".$wert2."' AND itemtype = '2148'";

 $ergebnis7 = mysql_query($abfrage7);
 
 $abfrage8 = "SELECT player_id, itemtype, count FROM player_depotitems WHERE player_id = '".$wert2."' AND itemtype = '2152'";

 $ergebnis8 = mysql_query($abfrage8);
 
 $abfrage9 = "SELECT player_id, itemtype, count FROM player_depotitems WHERE player_id = '".$wert2."' AND itemtype = '2160'";

 $ergebnis9 = mysql_query($abfrage9);
 
 

     while($row5 = mysql_fetch_array($ergebnis7))
{

    $money2 = $money2 + $row5["count"];

}

     while($row6 = mysql_fetch_array($ergebnis8))
{

    $money3 = $money3 + $row6["count"]*100;

}

     while($row7 = mysql_fetch_array($ergebnis9))
{

    $money4 = $money4 + $row7["count"]*10000;

}

        $money_all = $money2 + $money3 + $money4;
        array_push($money_each_chara, $money_all);
        $money2 = 0;
        $money3 = 0;
        $money4 = 0;
        $money_all = 0;
        $name_ord++;

    }
    
      }

     
        foreach ($money_each_chara as $key5 => $wertung)
         {

        echo "<br> $namen[$key5] has got $wertung gold.";
      }



         echo "<br> Complete money on account: <br> _________________ <br> <br> ".array_sum($money_each_chara)."";




}
 ?>