Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Community Forums
 Community Discussions (All other subjects)
 Help with Database Layout		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

redbrad0
Advanced Member

USA
3725 Posts
Posted - 05 November 2003 :  18:58:53  Show Profile  Visit redbrad0's Homepage
I am creating a new database for some products but trying to figure out the best way to layout the database. This is a very small shopping cart. The end result should produce something sorta like the following taking from another website

http://www.shabangexpress.com/sample.htm

So for the database layout I have currently


Category
	Cat_ID
	Cat_Name
	Cat_Desc
	Cat_Active
	
Products
	Prod_ID
	Prod_CatID
	Prod_Name
	Prod_Desc
	Prod_SmPic
	Prod_LgPic
	Prod_ListPrice
	Prod_SalePrice
	Prod_Active


Showhow I need to set different variables for each product which I was thinking something like

ProdItems
	Item_ID
	Item_ProdID
	Item_Name
	Item_Desc
	
ProdItemsDetail
	Detail_ID
	Detail_ItemID
	Detail_Name


I dont think the above would be the best way, any ideas or suggestions?
Brad
Oklahoma City Online Entertainment Guide
Oklahoma Event Tickets

Nikkol
Forum Moderator

USA
6907 Posts
Posted - 05 November 2003 :  19:01:32  Show Profile
give a concrete example ... what do you mean by item and then itemdetail?
Nikkol ~ Help Us Help You | ReadMe | 3.4.03 fixes | security fixes ~
Go to Top of Page

redbrad0
Advanced Member

USA
3725 Posts
Posted - 05 November 2003 :  19:05:35  Show Profile  Visit redbrad0's Homepage
The example is in the link in the post. Basically I was thinking I would have...

PRODUCTS Package 1(10ft)
ITEMS Select a Fabric Color...
ITEM DETAILS [i]drop down menu that has Apollo - 97157 listed as first one

I hope this helps a little more
Brad
Oklahoma City Online Entertainment Guide
Oklahoma Event Tickets
Go to Top of Page

Nikkol
Forum Moderator

USA
6907 Posts
Posted - 05 November 2003 :  19:21:09  Show Profile
Okay, I see. What you've detailed seems to be the best way to do it since a product can have multiple "items" (i would tend to call it something different since in your example it's not an item per se, more of a characteristic, but doesn't really matter since it's just the name of a table) ... anywho ... and each "item" can have more than one selection.

The only thing I could think would be that if you had several products that shared the same "items" and consequently "item details", then those two tables would be separate and you would have another that linked the products to the items. If that made any sense at all.
Nikkol ~ Help Us Help You | ReadMe | 3.4.03 fixes | security fixes ~
Go to Top of Page

redbrad0
Advanced Member

USA
3725 Posts
Posted - 05 November 2003 :  20:17:34  Show Profile  Visit redbrad0's Homepage
Yea that makes since, but some of the items (characteristics) are drop down menus, some are just text boxes with how many they want, and some how multiple drop down menus. So how would you think about handling that?
Brad
Oklahoma City Online Entertainment Guide
Oklahoma Event Tickets
Go to Top of Page

Nikkol
Forum Moderator

USA
6907 Posts
Posted - 05 November 2003 :  20:22:34  Show Profile
well, you could have a column in the item table that's called "itemtype" which could be for either "manual entry" or for "selection" .. if it's "selection", you'll know to look up what needs to fill the dropdown box by looking at the itemdetails table. if it's "manual entry" you know you need to display a text box.
Nikkol ~ Help Us Help You | ReadMe | 3.4.03 fixes | security fixes ~
Go to Top of Page

redbrad0
Advanced Member

USA
3725 Posts
Posted - 05 November 2003 :  20:28:34  Show Profile  Visit redbrad0's Homepage
Well let me try this out and see what happens. Thanks and will post if I need anymore ideas.
Brad
Oklahoma City Online Entertainment Guide
Oklahoma Event Tickets
Go to Top of Page

redbrad0
Advanced Member

USA
3725 Posts
Posted - 13 November 2003 :  15:23:03  Show Profile  Visit redbrad0's Homepage
I have most of the layout done, but what would be the best way to grab the dynamically driven form fields. Everything under the Additions in the given link ( http://www.shabangexpress.com/products.asp?id=2 ) is dymanically made. As of right now I have the form name as the ID number of that item.
Brad
Oklahoma City Online Entertainment Guide
Oklahoma Event Tickets
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.29 seconds. Powered By: Snitz Forums 2000 Version 3.4.07