I need to query an access database and display and sort some products from the database. The database has three tables:
Table # 1 is a list of products by a unique ID, description, an image path and popularity ranking (numberic, with 1 being the **LOWEST**).
Table # 2 is a unique id, a category name, and an image path for a header for that category.
Table # 3 has the product ID (table # 1), and the category ID (table # 2)
The same product may appear in table # 3 multiple times with differenty category ids.
The header image from trable # 2 should display above a two column table then how many rows are needed to show all the products within the category. 2 products per row, didplaying all the products that are within that category, in the sort order from the table sorted by the popularity ranking.
Currently this is done in HTML so I will provide the selected coder with the html page so they can see specifically what the layout will be.
This should be very simple for an asp coder, and I hope to have it back within a few hours of awarding the project.
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
I am attaching a very small SAMPLE version of the database for you to see the layout.
## Platform
asp