I would like to display data from two different mySQL tables which appears to work ok, except for one major problem...I am getting too many results...I have had only a quick explaination on how the joins work so far, but from what I have seen, I will need one of several different types of joining applied to the query..I don't know which one I need to use though. Here's the query in question that I am working with that gives too many results (more than what I expected)
$query="SELECT table1.column, table2.column FROM table1, table2";
Also, how would I handle a situation if both columns had the same name in the database of course their tables are different, but I have that situation as well.
$query="SELECT table1.title, table2.title FROM table1, table2";
Thank you in advance!
Last edited by Brian07002; 02-11-2012 at 09:56 AM..