Any suggestion pl?
Seena Blace <[EMAIL PROTECTED]> wrote:hi,
here is table description
report1
+-------------------------+------------------+------+-----+---------------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------------------+------------------+------+-----+---------------------+----------------+
| id | int(10) unsigned | | PRI | NULL | auto_increment |
| host_id | int(10) unsigned | | MUL | 0 | |
| report_rcpt_domain_id | int(10) unsigned | YES | MUL | NULL | |
| report_sender_domain_id | int(10) unsigned | YES | MUL | NULL | |
| report_ipaddress_id | int(10) unsigned | YES | MUL | NULL | |
| time | datetime | | MUL | 0000-00-00 00:00:00 | |
| detected_spam | int(10) unsigned | | | 0 | |
| detected_virus | int(10) unsigned | | | 0 | |
| processed | int(10) unsigned | | | 0 | |
| allowed | int(10) unsigned | | | 0 | |
| suspected | int(10) unsigned | | | 0 | |
| blocked | int(10) unsigned | | | 0 | |
| spam | int(10) unsigned | | | 0 | |
| virus | int(10) unsigned | | | 0 | |
I WANT REPORT LIKE FOLLOWINGS
date sender processed spam suspected
I want top 10 spam sender each day.
QUery i'm using
select date_format(time,'%Y-%d-%m'),report_sender_domain_id,processed ,spam
from report1
order by spam desc ,report_sender_domain_id,date_format(time,'%Y-%d-%m') limit
10;
Please suggest.
thanks
---------------------------------
Discover Yahoo!
Find restaurants, movies, travel & more fun for the weekend. Check it out!
---------------------------------
Do you Yahoo!?
Yahoo! Small Business - Try our new resources site!
