Shopping Cart

[larryman]

Please I need help on designing a shopping cart, i have 14 categories of tapes and each category has been tied to 14 tables in Access database respectively. Clicking on each of these category will open a page containing members of the category dynamically pulled from the database with checkboxes by their sides. I know how to track the result of each page but the problem is how to keep track of the selected boxes while the user browses the 14 pages.

Please if anybody has done this I would mind any help Oysterbar ride to success. Keep Riding

 

[MrGreed]

You could set session variables to keep track of the users selections (ASP).

Or (my prefered way) would be to create a cookie and store the info in it. That way if the user would leave your site and come back there selections would still be available. "did you just say Minkey?, yes that's what I said."

MrGreed

 

[snowboardr]

Mr Greed is right on that.. but..

Why do you need 14 tables for each category? I would recommend having one table called "invetory" and then have one column numeric for a value from 1-14, then make a table called "cat" (category) and make 2 columns one catID and one catName then on your entry page (where you enter inventory) create a drop down menu that would loop through the cat table

<option value=&quot;<%=rs(&quot;catID&quot;)%>&quot;><%=rs(&quot;catName&quot;)%></option>

Then you can create one page that shows all inventory.. not 14 pages..

Then you would you can draw from the database using a querystring and select statement like this:

strSQL = "SELECT from inventory WHERE category_table=" & Request.QueryString("cat&quot

Then to draw from a certain category you would have you a link like this:

show_tapes.asp?cat=14

Etc..


Hope that helps you out, will make your life easier doing it that way..

- Jason

ps. I'd upgrade to MySQL as well, access isnt a good db. www.vzio.com
ASP WEB DEVELOPMENT