I am a graphic artist working for a small family business and wearer of too many hats. I can design/build web sites in Dreamweaver and have average or above capabilities there but interaction with databases is now becoming a priority. I want to get some evening classes to help our family business in this area but not sure what I need to learn... Here's what I want to do:
We have a huge swap meet and car show several times a year that we sell vendor spaces and process their location on a printed wall map by hand. Each space is a rectangle on a overhead drawing of a fairgrounds. What I would like to do is have the ability to have this map online identifying filled and available spaces in real time? It would also be preferred if we could allow a vendor to click on the open space in the location they want and purchase the space without having to call us during our business hours.
I guess in actuality it's a 2-part question: 1) Is it possible to have a real-time map like attached that shows space availability 2) Can the same technology allow customers to select and purchase their own space online and have the map automatically update after their purchase?
I would think this is possible but have no idea where to start, or what to learn, to make this feature a possibility. Then again it could be so involved that it's just not worth it and we should keep using the large wall map? ;-)
I know I am probably in over my head but thought I would look into the possibilities. Thank you for your time.