mysql_query("SELECT * FROM reklamos ORDER BY apsilankymai DESC LIMIT 10");

 

    function calculateRank($rank) {

        $id = (int)$rank;

        $query = $this->db->prepare("SELECT * FROM reklamos WHERE id = ?");

        $query->execute(array($id));

        if($query->rowCount()) {

            $r = $query->fetch();

            $top = $this->db->prepare("SELECT * FROM reklamos ORDER BY visits LIMIT 1");

            $top->execute(array($id));

            $topr = $top->fetch();

 

            $final = $topr['visits'] - $r['visits'] / 100;

            return ($final > 0) ? $final : "---";

 

        }

        return false;

    }