Add and Subtract numbers

[duncon]

I am trying to achieve this ...

Each student will be selling cookies and candies for 7 days. Each of them will go to a webpage and type in the number of candies, cookies they sold. They can enter the numbers any time of the day. These numbers are going into a mysql database.

As a teacher I would like to go to a page and see how many cookies and candies each student sold and the total of cookies and a total of candies sold. How do I achieve this?

Thanks.

[mcrbids]

This can get very complicated depending on your need. You can start with something simple, eg:

1) create a table itemsold (date integer, staff varchar, item varchar, count integer);

2) When the students/staff enter in sales, generate a query like

"INSERT INTO itmesold (date, staff, item, count) VALUES ('20041025', 'Red Boxer shorts', 1)";

To aggregate the records:

Select (item, count(*) from ittemsold group by (item)

Or, for each sttaff member:

select(item, count(*) from itemsold group by staff, item ordrer by staff ASC";

does this help?