A little help sorting

[mikeysites]

Hi all,

Does anyone know how I can take a data table add all like entries & sort them by date?

 

Output is

quantity - title - size - date

I need to add all quantity with matching size & title then sort by date, I can do the sort but having issues with the adding.

I need it to print out a master detail of orders but dont want them to have to count how many of each.

 

So the print should show something like,

29 baked ziti large 09/29/2009

15 baked ziti small 09/29/2009

2 baked ziti medium 09/29/2009

 

I dont have code to post as I am stuck on how to add them based on the size.

 

Any help would be awesome, I hope my need is clear from what I wrote.

 

Thanx

Mike

[gevans]

Are you getting the data from a database?

[mikeysites]

Yes sorry the data is coming from a mysql data source.

[.josh]

select sum(quantity) as total from table where title='...' and size='...' order by date desc

 

may possibly need a group by in there.

[gevans]

this should work;

 

SELECT SUM(`quantity`) AS total_quantity, `title`, `size`, `date`
FROM `your-table`
GROUP BY `title`, `size`
ORDER BY `data` DESC;

 

You just need to substitute `your-table` for your table name

[mikeysites]

Thanks much I will try these & let you know how it goes.

[.josh]

use gevan's.  it's the same principle as mine but he filled in the blanks