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 Quote Link to comment 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? Quote Link to comment 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 Quote Link to comment 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.