Hi,

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)

PHP Code:

$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.

PHP Code:

$query="SELECT table1.title, table2.title FROM table1, table2"; 


Thank you in advance!
_Brian_

http://dev.mysql.com/doc/refman/5.0/en/join.html

What you're probably looking for is a left join.

SELECT table1.column, table2.column FROM table1 LEFT JOIN table2 ON (table1.foo = table2.bar);

For example, if I had a table people and a table jobs:

people:
id | name | job

jobs:
id | title

The following query would get every person's name and job title:

SELECT people.name as name, jobs.title as title FROM people LEFT JOIN jobs ON (people.job = jobs.id);

Thank you Matt, I will have a look later, I have to leave for work now. I will try it tonight.

Thanks again!
-Brian