Hiiiiiiiiii,I have problem to get the count of the data from the table,
my table is related to advtisements of users.
ADVTISE_ID -- primarykey
ADVTISE_TYPE ---- sales or wnated
NEWENTRIES -- newentries
addate -- advtisement posting date


i need to display the data count from abc table based on above columns and date.
Example--
In my webpage counts like--
WANTED 20
SALES 30
NEWENTRIES 5
Here 20,30,5 is count
But we like to display new entries weekly but sales and wanted entire rows count.
I hope u can understand.
plss help me
thanks
kavitha