[Deprecated] DMZ 1.5.3 (DataMapper OverZealous Edition)

[eluser]OverZealous[/eluser]
[quote author="ZeusChicago" date="1253142670"]
...
But to my dismay, even though the $previousSubDataCount spits out 2 (which I have 2 records) the foreach($previousSubData as $preData){} loop only prints out 1 record.
...
[/quote]

Well, one thing is wrong here, for sure — you have to rebuild your queries between get(s), count(s), and the like. ActiveRecord deletes the old query information between queries, so you can have run a new query each time.

If you looked at your query output (by turning on CI's profiler — it's in the Troubleshooting Section), you'd see that your count() query is basically doing:

Code:

COUNT(*) FROM subscriptions

So it's returning all rows. If you need two of the same query, you can either use DMZ/AR's caching, or build the query twice.


But you don't need to do this at all!
The DMZ count method is used when you do not want the results, just the number of items, because it runs a query. If you want to know how many items are returned normally, just use count($object->all)!

(Also, if you are using a non-current DMZ, you might need to add distinct to your query, because older DMZ's automatically collapsed items with the same ID into one result.)