hi guys i have another problem , hope u can give me some pointers.
below is the project i am doing to give it a clearer overview

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
My needed project

A very simple food menu tracking form and statistics form

1) a client-side ASP form page (for waiters) that has e.g 4 checkbox available for them to choose

> pasta
> coke
> pizza
> sides

- they can select 1-4 checkbox and when submit, they will be submitting to a DB

next

2) a server side ASP form to display the selection trend as inserted abv (sort of a statistics page) and retrieve info from the DB

- the stats that i need in that page

1) how many orders for that day (!!! problem here)
2) food selection

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

my problem right now is how to determine which field for the "how many orders for that day"

as my db field is only ( date, selection,waiter name, waiter ID)

hope u guys can give me some pointers
appreciated =)

have a look at the followign sub clauases in the SELECT statement

SUM(<mycolumn#1>)
AND
GROUP BY <mycolumn#2>;
usage is
SELECT <mycolumn#1>,SUM(<mycolumn#2>) FROM <mytable> GROUP BY <mycolumn#1>;

might want to consider the COUNT() aggregate function for the "how many orders per day" question

..good point, but I did think silverxc had to do something to get the answer they are looking for

hi guys i think my qn might not be phrased very correctly

wat i need to find out is @ my statistics page , i need to display the no. of orders for a particular day , but however now my tracking is only based on

as my db field is only ( date, selection,waiter name, waiter ID)

and this insert statement can happen 2-3 times but for only one order

1) ONE ORDER but with 2 items
20/11/06 pasta steven 4077
20/11/06 calamari steven 4077

so i need to think of a field to collate the orders. and this is the headache i am facing, hope u guys can give me some pointers.

so what have you tried so far, and what about your attempt that isnt working?

yup thats the thing.. i cant figure out which field shld i add on to track the orders.

things i am pondering right now is shld i open another table just to track the field?

hi guys i have thgt of an idea but suspect its not very effective in some ways.


wat i can think of is to create another table just to store the orders.
this can solve my problems right now but is there any better ideas u can advise me?

thanks in advance