Guys;

I'm executing this custom SQL:

                $sql = "select
                          c_product_id,
                          count(*) as count
                    from
                        c_combocontents,
                        c_combos
                    where
                         c_combos.id = c_combo_id
                         and
                         c_optioncontent_id in (1,2,3,4,5)
                         and
                         c_combos.current =1
                    group by c_product_id,c_combo_id";

$oc = $this->modelname->query($sql);

The results i'm getting produce an array like this in dev (xp,mysql)

Array
(
[0] => Array
(
[c_combos] => Array
(
[c_product_id] => 477
)

[#sql_dc8_0] => Array
(
[count] => 1
)
)
)



The problem is that the "#sql_dc8_0" bit changes all the time, in my live linux env the key seems to be a zero all the time. Does anyone have any ideas on this one? I have dug though the low level code but cant actually find where it creates the array.

Cheers,
Matt

 





--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake PHP" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/cake-php
-~----------~----~----~----~------~----~------~--~---

Reply via email to