adaminms Posted January 29, 2010 Share Posted January 29, 2010 I'm wanting to make a site that has two sets of information, which will both have tables in a database. What I want to do is be able to compare the information from one table, to the other, and list matches (in all of the fields) on the webpage. Link to comment https://forums.phpfreaks.com/topic/190189-hello/ Share on other sites More sharing options...
lathifmca Posted January 29, 2010 Share Posted January 29, 2010 can u describe the table structure of your database tables.. if both of your tables have a same Column (or type of) Eg: Table1 has NAME column, Table2 has CNAME, then u need compare those with the query like "Select * from table1,table2 where table1.NAME = table2.CNAME", this will give the same matches in NAME and CNAME of the Table1 and Table2.. Link to comment https://forums.phpfreaks.com/topic/190189-hello/#findComment-1003431 Share on other sites More sharing options...
adaminms Posted January 29, 2010 Author Share Posted January 29, 2010 Table 1 first_name varchar last_name varchar education varchar age int sex varchar type varchar position varchar hours varchar location varchar Table 2 name varchar type varchar position varchar education varchar location varchar I'm only wanting to cross-reference the ones that are named the same in both tables. Like a matching game, I guess. Link to comment https://forums.phpfreaks.com/topic/190189-hello/#findComment-1003930 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.