class MemberStats { var $name; var $mysqli; var $member_id; var $raid_count; var $fabled; var $legendary; var $treasured; function __construct($id) { $this->member_id = $id; $this->populateStats(); $this->mysqli = MySQLi(); } function populateStats() { $statement = "SELECT count(*) as raidcount FROM `icono`.`raid_attendance` LEFT JOIN icono.raid_members on icono.raid_attendance.member_id = icono.raid_members.id where member_id = '".$this->member_id."'"; $result = $this->mysqli->query($statement); } }