see i have data base(report_info) in that i have 3 table one for which type of site is it. 2nd is site info. and 3rd is main table visitor information and in this table i have all information about visitor's with site id....as foreign key.... in this table i have lots of fields but 5 of them are most visited1,most visited 2, most visited 3,most visited 4, most visited 5 in this field site names are thr..... like which 5 site's are most visited today.... like that for every day......
in my report i have to pass site id....and date range as parameter...... and with this site id i have to do group by data...... but i have to find 5 most visited site from table visitor information table's most visited1,2,3,4,5 field......
hope i cleared my self....
IP Logged
you knw i was working on this from last day
