follows on SMAS table
> select campaignName, siteName, adnetwork,date_format(loggingTime
,'%d/%m/%Y') logDate, count(distinct requestid) adpage
from SMAS where sucess = 1 GROUP BY 1,2,3,4
--
John
_____
0| 699 | 646855 |
--
John
_______
John Murtari Software Workshop Inc.
[EMAIL PROTECTED] 315.635.1968(x-211) "TheBook.Com" (TM)
http://www.thebook.c
Jeremy Zawodny writes:
> On Fri, Oct 03, 2003 at 08:29:17AM -0400, John Murtari wrote:
> > Folks,
> >
> > I've done a lot of searches, tried out the tools I could
> > find (like phpMyAdmin/mtop). We have a server with about 30 DB's
> > a
data available.
Best regards!
--
John
_______
John Murtari Software Workshop Inc.
[EMAIL PROTECTED] 315.695.1301(x-211)"TheBook.Com" (TM)
ht