$rows = $mydb->get_results("SELECT nev,foosztaly,szine FROM gems");


foreach ($rows as $row)
        {
            echo "Név: " . $row{'nev'} . " class: " . $row{'foosztaly'} . " szine: ". $row{'szine'};
            echo "<br>";
        }



}