Jump to content

MySQL- Adding fields ...


bsamson

Recommended Posts

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!

Link to comment
https://forums.phpfreaks.com/topic/99704-mysql-adding-fields/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.