Welcome to WebmasterWorld Guest from 107.21.149.142

Forum Moderators: open

Message Too Old, No Replies

Database Overview

     
10:21 am on Oct 10, 2005 (gmt 0)

Junior Member

10+ Year Member

joined:Oct 8, 2005
posts:48
votes: 0


I have 4 tables: users, service, purchases, quotes
I am currently trying to make a stats page and have like
Total Users: $users_amount
Total Purchases: $purchases_amount
Total Quotes: $quote_amount
Total Services: $services_amount

Then for all of these tables, i have a date field, which shows when it was added, and want to have How many for the Month. Total Users Added this MOnth, Total Purchases This month, Total Quotes this Month, Total Services this month. Then also for service i have a status column, complete/uncomplete. I would like to have on the report 'Total Unfinished Service:'. Is anyone able to point me in the right direction, or for a good tutorial. THankyou very much