>  I guess you mean your main table:
>
>  Inefficient method:
>
>  In your controller:
>
>  $total_num_rows = count($this->Model->find('all'));
>
>  More efficient method, also works if you would like to do it on several 
> tables.
>
>  $num = $this->query("SELECT COUNT(*) FROM table_a, table_b");

ermm

most efficient method:

$total_num_rows = $this->Model->find('count');

happy new year bakers!

j


-- 

jon bennett
w: http://www.jben.net/
iChat (AIM): jbendotnet Skype: jon-bennett

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"CakePHP" 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?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to