richarro1234 Posted January 20, 2010 Share Posted January 20, 2010 Hello, Im trying to setup something with a supply and demand schema. for example: i buy a business and it supplies item 1,4 but it demands item 2,3,5 (like a grain mill requires grain, to produce flour) But im not sure how to go about setting this up. Can someone please help me set this up so that i can add businesses to a database and have the supply number and demand number for that business and then have it display the name of the item on the web page. Thanks Rich Link to comment https://forums.phpfreaks.com/topic/189173-need-some-help-with-a-problem/ Share on other sites More sharing options...
p2grace Posted January 20, 2010 Share Posted January 20, 2010 I would actually create 3 database tables, using 1-to-many relationships. 1 db table for businesses 1 db table for supply which has a businessID 1 db table for demand which has a businessID Make sense? Link to comment https://forums.phpfreaks.com/topic/189173-need-some-help-with-a-problem/#findComment-998722 Share on other sites More sharing options...
ignace Posted January 20, 2010 Share Posted January 20, 2010 Read this: http://www.phpfreaks.com/forums/index.php/topic,268089.msg1264949.html#msg1264949 Link to comment https://forums.phpfreaks.com/topic/189173-need-some-help-with-a-problem/#findComment-998724 Share on other sites More sharing options...
richarro1234 Posted January 20, 2010 Author Share Posted January 20, 2010 Yea ive got that at the moment, but its not showing up the second demand on the website. Link to comment https://forums.phpfreaks.com/topic/189173-need-some-help-with-a-problem/#findComment-998725 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.