Our boss wants us to design a webpage called KC Metro Free Stuff...  this is a feature to drag people into his other sites which are realty, and a couple of other random things. he plans on this getting big, so updating is going to be an enormous job.

Basically, this site will have coupons for random places in the suburbs of Kansas City.  It will also list random stuff in the community... Churches, schools, day cares, grocery stores, restraunts...  The list goes on and on...  

what I am thinking about doing is starting out with a very basic HTML design, and working our way up.  I will want a database to update the site without going in and hard coding the suker again.  how I want the database (for the coupons) to work is as following:
	
	CouponID#: ID of coupon
	Start Date: When the coupon will be accessible
	End Date: When the coupon will stop appearing
	City:  What city it is in
	Category: What it is
	Company: Who owns it
	Address: Where it is at
	Phone: who to call
	Email: who to email
	Image: the coupon image

Ok...  So...  When a user logs on to the main page...  They will find a page with two links:  one that says "Free deals in the Kansas City Metro!" and other that says something close to "City Guide."  When a user clicks on the latter, I want a page to pop up with all the cities that have active deals in them.  This list will be autogenerate based on what deals are active in what cities... example:

A deal is active in Blue Springs and another one in Kansas City.  The page displays

	Click here for deals in: 

	Blue Springs
	Kansas City

The deal in Blue Springs expires the next time the user logs on, so it will just say

	Click here for deals in:

	Kansas City

Ok, the user clicks on "Blue Springs"  User will get a list, again auto generated, that will look some thing like this...

	Restraunts:
	
	Burger King
	Mc Donalds
	Wendy's
	Taco Bell

	General Stores:
	
	Walmart
	Target
	
	Grocery Stores:
	
	Price Chopper
	Hyvee

	etc...

When the User clicks on Taco Bell, a page that looks like this will look like this:
	
	
	Taco Bell
	1337 leet st
	Blue Springs, MO 64014
	(816) 010 - 1337
	tacobell@tacobell.com
	Valid through: 01/01/07 - 02/01/07
	

	BIG COUPON IMAGE HERE
	
	*in small text* Coupon ID 236312
	
	

If any of that info isnt there, it just isnt printed.