Multiple Tables?

This topic is locked

Multiple Tables?	11/25/2007 9:17:47 AM
PHPRunner General questions
N nickrix author Is it possible to display data from 2 different tables on one page if i have a unique ref number to match them both? i have a table with basic company information and another with financial data . both tables contain the unique ref number to match them both up however i am wondering if PHPRunner will let me display data from both tables on one page?? im asking if it is possible for just 2 tables however i am looking to create other tables too so also could you let me know if it is possible to pull data from more than 2 tables. any replies will be greatly apreciated. Nick


	kujox 11/25/2007
	Is it possible to display data from 2 different tables on one page if i have a unique ref number to match them both? i have a table with basic company information and another with financial data . both tables contain the unique ref number to match them both up however i am wondering if PHPRunner will let me display data from both tables on one page?? im asking if it is possible for just 2 tables however i am looking to create other tables too so also could you let me know if it is possible to pull data from more than 2 tables. Yes it is, you need to select from both tables in the mysql section of phprunner SELECT table1.field1,table1.field2,table2.field3,table2.field4 FROM table1,table2 WHERE table1.companyID = table2.companyID if that doesn't make sense just search the forum for MYSQL JOIN, it has been answered loads of times so you should find plenty of examples