$mywep = $db -> SelectLimit("SELECT * FROM equipment WHERE owner=".$player -> id." AND type='W' AND status='E'", 1);

    $myarm = $db -> SelectLimit("SELECT * FROM equipment WHERE owner=".$player -> id." AND type='A' AND status='E'", 1);

    $myhelm = $db -> SelectLimit("SELECT * FROM equipment WHERE owner=".$player -> id." AND type='H' AND status='E'", 1);

    $mylegs = $db -> SelectLimit("SELECT * FROM equipment WHERE owner=".$player -> id." AND type='N' AND status='E'", 1);

    $mygloves = $db -> SelectLimit("SELECT * FROM equipment WHERE owner=".$player -> id." AND type='Q' AND status='E'", 1);

    $myboots = $db -> SelectLimit("SELECT * FROM equipment WHERE owner=".$player -> id." AND type='X' AND status='E'", 1);

    $myrings = $db -> SelectLimit("SELECT * FROM equipment WHERE owner=".$player -> id." AND type='I' AND status='E'", 1);

    $myamuls = $db -> SelectLimit("SELECT * FROM equipment WHERE owner=".$player -> id." AND type='J' AND status='E'", 1);

    $ewep = $db -> SelectLimit("SELECT * FROM equipment WHERE owner=".$arrdefender['id']." AND type='W' AND status='E'", 1);

    $earm = $db -> SelectLimit("SELECT * FROM equipment WHERE owner=".$arrdefender['id']." AND type='A' AND status='E'", 1);

    $ehelm = $db -> SelectLimit("SELECT * FROM equipment WHERE owner=".$arrdefender['id']." AND type='H' AND status='E'", 1);

    $elegs = $db -> SelectLimit("SELECT * FROM equipment WHERE owner=".$arrdefender['id']." AND type='N' AND status='E'", 1);

    $egloves = $db -> SelectLimit("SELECT * FROM equipment WHERE owner=".$arrdefender['id']." AND type='Q' AND status='E'", 1);

    $eboots = $db -> SelectLimit("SELECT * FROM equipment WHERE owner=".$arrdefender['id']." AND type='X' AND status='E'", 1);

    $erings = $db -> SelectLimit("SELECT * FROM equipment WHERE owner=".$arrdefender['id']." AND type='I' AND status='E'", 1);

    $eamuls = $db -> SelectLimit("SELECT * FROM equipment WHERE owner=".$arrdefender['id']." AND type='J' AND status='E'", 1);

    $myczar = $db -> SelectLimit("SELECT * FROM czary WHERE gracz=".$player -> id." AND status='E' AND typ='B'", 1);

    $eczar = $db -> SelectLimit("SELECT * FROM czary WHERE gracz=".$arrdefender['id']." AND status='E' AND typ='B'", 1);

    $myczaro = $db -> SelectLimit("SELECT * FROM czary WHERE gracz=".$player -> id." AND status='E' AND typ='O'", 1);

    $eczaro = $db -> SelectLimit("SELECT * FROM czary WHERE gracz=".$arrdefender['id']." AND status='E' AND typ='O'", 1);

    $mybow = $db -> SelectLimit("SELECT * FROM equipment WHERE owner=".$player -> id." AND type='B' AND status='E'", 1);

    $ebow = $db -> SelectLimit("SELECT * FROM equipment WHERE owner=".$arrdefender['id']." AND type='B' AND status='E'", 1);

    $myarrows = $db -> SelectLimit("SELECT * FROM equipment WHERE owner=".$player -> id." AND type='R' AND status='E'", 1);

    $earrows = $db -> SelectLimit("SELECT * FROM equipment WHERE owner=".$arrdefender['id']." AND type='R' AND status='E'", 1);

    $mystaff = $db -> SelectLimit("SELECT * FROM equipment WHERE owner=".$player -> id." AND type='S' AND status='E'", 1);

    $estaff =  $db -> SelectLimit("SELECT * FROM equipment WHERE owner=".$arrdefender['id']." AND type='S' AND status='E'", 1);

    $mycape = $db -> SelectLimit("SELECT * FROM equipment WHERE owner=".$player -> id." AND type='Z' AND status='E'", 1);

    $ecape = $db -> SelectLimit("SELECT * FROM equipment WHERE owner=".$arrdefender['id']." AND type='Z' AND status='E'", 1);

    $myshield = $db -> SelectLimit("SELECT * FROM equipment WHERE owner=".$player -> id." AND type='D' AND status='E'", 1);

    $eshield = $db -> SelectLimit("SELECT * FROM equipment WHERE owner=".$arrdefender['id']." AND type='D' AND status='E'", 1);

$sql = mysql_query("SELECT *
FROM equipment
WHERE owner=".$player -> id." AND status='E' ORDER BY id ASC") or error("bład");

while($wiersz = mysql_fetch_array($sql))
{
print "Pole pierwsze".$wiersz['id']."<br>";
print "Pole drugie".$wiersz['owner']."<br>";
print "Pole trzecie".$wiersz['type']."<br>";
}

extract($wiersz);