Home Community Mys-Script Creative Off-Topic |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Show amounts and totals of adoptables
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:
Last edited by Chaos77777; 01-19-2017 at 04:58 PM. |
#2
|
||||
|
||||
The array you use inside a db->select() is the array with the names of the columns that have the information you want to retrieve. What array_unique does is to remove duplicates from that array. So you can't use array_unique inside a db->select for what you want to do.
The usual database functionality that does what you want is Select Distinct, however I don't know how to do that with mysidia's database calls without creating a new database function. So I guess the easiest way is like this: PHP Code:
__________________
asp.net stole my soul. |
#3
|
|||
|
|||
->fetchAll(PDO::FETCH_UNIQUE)
That's what I needed, right there. Once again, you're awesome! You get a dedicated thank you on my site when it's ready :D |
#4
|
||||
|
||||
No problem, glad to help :D
__________________
asp.net stole my soul. |
#5
|
|||
|
|||
I ran into another snag on this one. Do you happen to know if there's a way I can have it look into two separate arrays? For instance, these don't work, but I think it'll show you what I'm trying to accomplish
$owned1= $mysidia->db->select("owned_adoptables", array("type" AND "subtype"), "owner = '{$mysidia->user->username})->fetchAll(PDO::FETCH_UNIQUE); $owned1= count($owned); OR $owned1= $mysidia->db->select("owned_adoptables", array("type"), "owner = '{$mysidia->user->username} AND subtype= "ALL")->fetchAll(PDO::FETCH_UNIQUE); $owned1= count($owned); Since I have it set up to have subtypes of each type lol, It'll count all the types while disregarding the subtypes. I can't just do the array "subtype" because there are subtypes that are the same type and types that are the same subtypes lol :( I didn't think this one through when I started up. The top one disregards my "AND 'subtype'" and only numbers the types. The second one doesn't work cuz there's no subtype "all" lol. Leaving it blank gives the same thing too Lol I thought I was being smart and doing $owned1= $mysidia->db->select("owned_adoptables", array("type"), "owner = '{$mysidia->user->username} AND subtype != "")->fetchAll(PDO::FETCH_UNIQUE); $owned1= count($owned); But that just gave the same results as the top one Last edited by Chaos77777; 01-20-2017 at 05:41 PM. |
#6
|
||||
|
||||
Hmm I'm not sure I get it, but would something like this work?
PHP Code:
__________________
asp.net stole my soul. |
#7
|
|||
|
|||
:( no, same results. It's only searching by type while disregarding subtype. I'm trying a few other things. If I happen to find something that works, I'll post it. Unless you come up with something first.
|
#8
|
|||
|
|||
Say if I have "american" as the type, and "dog" as the subtype. Well, if I have an "american" "cat" also lined up where "american" is also the type of the "cat" subtype, then it still only shows one result. That's just an example, not exactly what I'm doing. I COULD just make their types "American Dog" and "American Cat" and get the proper results, but it would look pretty funny in other areas I set up to have them separated
|
#9
|
||||
|
||||
So you have something like this:
The group by I posted should be outputting a count of 4 in this case
__________________
asp.net stole my soul. |
#10
|
|||
|
|||
Yes, but in the case where there would be European Cat at the bottom, it still shows 4. Not 5
|
|
|
What's New? |
What's Hot? |
What's Popular? |