HOW TO DO THIS.

I have a table
id
buyer_id
item_code
contractor_id
price
dt
item_name

Now I want display dt(date) wise billing but contactor also will be in
sequence like this:

Contractor buyer_id item_code price
item_name
A 12 2112
S jgj
A
14 ..............................................
----------------------------------------------------------------------------------------------
sum(price)

B ......................................................................................
B ......................................................................................
B ......................................................................................
----------------------------------------------------------------------------------------------
sum(price)
C ......................................................................................
C ......................................................................................
C ......................................................................................
----------------------------------------------------------------------------------------------
sum(price)

how to write the query.

--
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
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php