| | |
How to Build a database
Please support our MySQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
![]() |
•
•
Join Date: Jan 2009
Posts: 13
Reputation:
Solved Threads: 0
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
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
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.
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
-- NASA
•
•
Join Date: Jan 2009
Posts: 13
Reputation:
Solved Threads: 0
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 ....
![]() |
Similar Threads
- database problem (C#)
- Looking to allow users to build a database for a Sports site (Database Design)
- build database with vb and microso (Visual Basic 4 / 5 / 6)
- Please guide me in making an airlines database (C)
- Database question.. Can someone help... (Database Design)
- This Database is a Monster (MS Access and FileMaker Pro)
- Building a database application (C++)
Other Threads in the MySQL Forum
- Previous Thread: Compare a column's value
- Next Thread: How to retrive all matched values in mysql?
| Thread Tools | Search this Thread |
agplv3 alfresco amazon api artisticlicense aws bizspark breathalyzer camparingtocolumns changingprices cmg communityjournalism contentmanagement contractors copyright count court crm database design developer distinct drupal dui ec2 email enterprise eudora facebook form foss gartner gnu government gpl greenit groklaw groupware hiring hyperic images innerjoins insert ip joebrockmeier join journalism keyword keywords kickfire laptop law legal license licensing linux maintenance managing mariadb matchingcolumns micromanage microsoft microsoftexchange mindtouch montywidenius mozilla multiple music mysql mysqlcolumnupdating mysqldatetimeordermax() mysqlindex mysqlquery mysqlsearch news open-xchange opendatabasealliance opengovernment opensource oracle penelope php priceupdating query referencedesign reorderingcolumns resultset saas select sharepoint simpledb sourcecode spotify sql sugarcrm syntax techsupport thunderbird transparency virtualization





