Hi
I would like to count some rows but i can't print results of query
exactly - count(*) AS kl - on the screen.
this is my query, and there is no error
$res = $this->DepartmentBook->find('all', array(
'fields' =>
array(
'count(*) AS kl',
'DepartmentBook.department_id'
),
'conditions' =>
array(
'DepartmentBook.extract_date' => null,
),
'order' =>
array(
'DepartmentBook.department_id'
),
'group' =>
array(
'DepartmentBook.department_id'
)
));
Only when i try to print on screen like that:
for($i = 0; $i < count($res); $i++){
echo $res[$i]['DepartmentBook']['kl'].'
'.$res[$i]['DepartmentBook']['department_id'].'<br>';
}
it's showing me this:
Notice (8): Undefined index: kl
[APP\views\stats_months\current_graph.ctp, line 13]
What should I type here $res[$i]['DepartmentBook']['?????']
--
Dominik Gajewski
--
Our newest site for the community: CakePHP Video Tutorials
http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others
with their CakePHP related questions.
To unsubscribe from this group, send email to
[email protected] For more options, visit this group at
http://groups.google.com/group/cake-php
