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
[email protected] For more options, visit this group at
http://groups.google.com/group/cake-php
