Re: count(*) in custom query

2006-11-08 Thread [EMAIL PROTECTED]
I'm wondering if anyone has any idea as to the reason for this little annoyance, as it's cropping up for me too (when I get a COUNT() in a custom query within cake)? Though I don't recall it in previous builds of cake and wonder if its due to something new? -Ryan Kevin Uni wrote: hi DJ Spark

Re: count(*) in custom query

2006-11-08 Thread nate
See if using findCount makes a difference. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Cake PHP group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email

Re: count(*) in custom query

2006-10-16 Thread Kevin Uni
hi DJ Spark, I am using 2 servers Developer Sever:(works well) Debian linux php 4.4.2 mysql 4.1 Product Server:(problem occurred) Redhat linux RS4 php4.3.9 mysql 4.1 So i changed my code,sample: $keys = array_keys($result[$i]); echo $result[$i][$keys[0]]['num']; On Oct 9, 9:05 am, DJ Spark

Re: count(*) in custom query

2006-10-10 Thread nate
It has to do with your database configuration (possibly the encoding of the table?). Someone who knows more on the subject should weigh in here, but the problem is definitely with the db. --~--~-~--~~~---~--~~ You received this message because you are subscribed

Re: count(*) in custom query

2006-10-10 Thread DJ Spark
i'll try changing that , and see if the problem disappears. thanks , nate (again :) spark On 10/10/06, nate [EMAIL PROTECTED] wrote: It has to do with your database configuration (possibly the encoding of the table?). Someone who knows more on the subject should weigh in here, but the

Re: count(*) in custom query

2006-10-08 Thread DJ Spark
I had the same problem here. how is your configuration ? mine is: - winXP - mysql 5 - php 5 - apache 1.3 spark On 10/8/06, Kevin Uni [EMAIL PROTECTED] wrote: Hi all, I am using cake to do a custom query just like select count(*) as num .. from tab1 left join tab2 on tab1.id = tab2.tid

count(*) in custom query

2006-10-07 Thread Kevin Uni
Hi all, I am using cake to do a custom query just like select count(*) as num .. from tab1 left join tab2 on tab1.id = tab2.tid inner join tab3 on tab3.id =tab2.did group by tab1.id . and cake return an Array called $result , it has something like $result[$i][0]['num'], but when I put it on