MySQL- Adding fields ...

[bsamson]

Hello,

  I have a DB named REPORTS. Here's the structure ...

 

ID

ENTRYDATE

STORE

NEWACTS

12MOACTS

22MOACTS

 

Basically this is a small internal website that serves 20 stores. Each store has to complete a report on the site every night that gets put into the DB. Each store is assigned a STORE # which is what is stored in the STORE field. The number never changes and is unique to that store.

 

Every Store completes this report every night. Now, I need to create a PHP script that computes how many NEW activations(month to date) each store has done and display the top 2 stores. This needs to be repeated for 12MOACTS and 22MOACTS.

 

By the way, the NEWACTS, 12MOACTS, and 22MOACTS are new activations which are reported daily.

 

  Any help will be GREATLY appreciated! Thanks!

[DanielWhite]

First off all you need to store every months data

 

01MOACT ect or you won't be able to calculate 12 and 22.

[bsamson]

Let me clarify ...

 

Let's go with these fields instead:

ID

ENTRYDATE

STORE

NEWACTS

UPGACTS

 

  How do I add all the new acts for each store then grab the the store with the highest new acts?

 

[bsamson]

** Bump **

[craygo]

something like this. (not tested)

 

$sql = "SELECT count(`NEWACTS`) AS `totalnew`, `STORE` FROM `REPORTS` GROUP BY `STORE` ORDER BY `totalnew` DESC LIMIT 1";

 

Ray