How to Build a database

Reply

Join Date: Jan 2009
Posts: 13
Reputation: jorgeberber is an unknown quantity at this point 
Solved Threads: 0
jorgeberber jorgeberber is offline Offline
Newbie Poster

How to Build a database

 
0
  #1
Jul 8th, 2009
Ok help please , cant get my head around this ....

i need to build a database that will hold the following :

width x drop = price
what i actually want to do is a quotation form for my website where the costumer will input the width and the drop and get a price as a result, But here is where i get lost, cuz the size of blinds can vary in thousands of combinations how would i build a database holding that info?
would i have to create tables with all the combinations possible and its price? or there is a simpler way of doing that ...
please helppppp..
thanks
Reply With Quote Quick reply to this message  
Join Date: Jul 2006
Posts: 831
Reputation: pritaeas will become famous soon enough pritaeas will become famous soon enough 
Solved Threads: 136
Sponsor
pritaeas's Avatar
pritaeas pritaeas is offline Offline
Practically a Posting Shark

Re: How to Build a database

 
0
  #2
Jul 8th, 2009
You could create a db holding all the different combinations, but that is probably not a very workable solution.

In my opinion you should work with a base price, so you get a general price. Then you could add different combinations as upgrades/downgrades.

In any case, somewhere this information needs to be entered to get an exact price, no matter what solution you want to provide. I'd suggest you think about how you'd want a customer to experience requesting a quote first, then build a solution to match that.
"If it is NOT source, it is NOT software."
-- NASA
Reply With Quote Quick reply to this message  
Join Date: Jan 2009
Posts: 13
Reputation: jorgeberber is an unknown quantity at this point 
Solved Threads: 0
jorgeberber jorgeberber is offline Offline
Newbie Poster

Re: How to Build a database

 
0
  #3
Jul 8th, 2009
yes the base price was my first idea, actually i made a whole form where the customer inpute the width and the drop and gets a result , but i have no clue how to grab that result "price" into a lets say shopping cart or confirmation page .... paypal buttons r not very helpfull in this situation cuz they only work with fixed prices ....
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:


Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC