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.