I'm a little intimadated now... I'm not familiar upper and lower bounderies.
Are you saying that I should have the following table structure:
tblShippingRates
=====================
rate_ID (autonumber/primary)
rate_Lower (min total)
rate_Upper (max total)
rate_Price (currency/cost of shipping)...
What would be the best way to design a table for flat rate shipping based on order total value?
The shipping rates would be something like this:
From $1-20.00 = $3.50; $20.01-50.00 = 5.95; $50.01-75.00 = $7.95 etc. etc.
I am designing an eCommerce website and I need to create some tables in my...
Remou,
I posted this same thread on another forum (http://www.tek-tips.com/viewthread.cfm?qid=1168367) before noticing that this forum is more appropriate... oops!
I am surprised to find that someone on the other forum responded before anyone on this forum given that the other forum is about...
I think I'm begining to see the relationships more clearly now, I am diagraming this out and thinking of the SQL necessary for the drill-down and detail pages.
Thanks!
-Aaron
P.S. The mp3 files are church sermons that we have recorded, so yes, this is legal... I thought about mentioning this...
I am developing a ColdFusion web application and I need help designing the backend. I posted this same thread on another forum before noticing that this forum is more appropriate.
Overview:
I am developing a website that is centered on broadcasting live & onDemand Flash Video and mp3 files, and...
Overview:
I am developing a website that is centered on broadcasting live & onDemand Flash Video and mp3 files, and then selling them on DVD, CD or download. This translates into several tables with many relationships and I am uncertain how to go about designing my database.
Paticulars:
I have...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.