Hey guys. I almost have it down. I got it showing how many total adopts a player has, but I can't make it show how many different types you own.
PHP Code:
$array = array($mysidia->db->select("owned_adoptables", array("type")));
$owned = $mysidia->db->select("owned_adoptables", array_unique($array), "owner = '{$mysidia->user->username}'")->rowCount();
$owned1 = $mysidia->db->select("owned_adoptables", array("owner"), "owner = '{$mysidia->user->username}'")->rowCount();
$lang['title'] = "Your Animals. You own {$owned} different species, and {$owned1} total species!";
owned1 shows the total amount a player has, and it works just fine. However, I can't get owned working right, been trying several different ways that I know of (which isn't many lol) with $array, such as $array = array("type") which still shows all owned total, $array = array($adopt->type) which gives me an Uncaught exception 'Exception' with message 'Database error 1054, and I even tried different things with array_unique. No luck. Maybe someone else knows what I'm missing. Thanks guys