Dual MySQL Database Query issue

helz

basically i was wondering whether i can get two mysql queries into one.
here are the two seperate sql statements:

SELECT DID, DirName FROM table1 WHERE SID='$int'

SELECT AddonID, AddonTitle FROM table 2 WHERE DID='$int'

They both have a column that uses the same data in the where clause but there are different columns required from each.
is there a special mysql query command that can be used? something that would join the two where clauses together

thanks for your time

bubblocity

Is SID column always matching DID column?

I think this might be what you want:

SELECT table1.DID, table2.DirName,
table2.AddonID, table2.AddonTitle
FROM table1 , table2
WHERE table1.SID = table2.DID
AND table1.SID='$int'

helz

that query looks about right, but maybe im going about this the wrong way
basically ive got a table, and each column of that table gets data from its own sql statement (the original two) but the problem is that you cant directly output them both since it would do one column vertically and then the other.
I was hoping to see if merging the two statements together could somehow group the results.
So really the where clause needs to be an OR instead of an AND since there might not be any results for one of the columns

bubblocity

I'm not sure if you can do this on your version of MySQL, I think version 4 and greater supports UNION or UNION ALL.

Can you do a UNION? (I think the only stipulation to UNIONs, is that the columns have to be the same in both queries, so you could substitute NULLs for nonmatching columns)

SELECT DID, DirName, 
NULL as AddonID, NULL as AddonTitle
FROM table1 WHERE SID='$int' 

UNION

SELECT NULL as DID, NULL as DirName, 
AddonID, AddonTitle FROM table 2 WHERE DID='$int'

Also, I think UNION groups the results to make them unique, and UNION ALL returns all rows

Is this kind of close?

helz

thats perfect!
at the moment ive only got data from one of the queries, but will report back when i test the two together

helz

hmm, your sql query only displays results from the first part of the query and not the second

when i flip part of the columns round in the second query:

SELECT NULL as DID, NULL as DirName, AddonID, Title FROM 

Becomes...

SELECT AddonID, Title, NULL as DID, NULL as DirName FROM

once edited it retrieves values from both queries but displays them using the columns in the first query. ie:
DID and DirName twice, instead of
DID DirName AddonID Title

would it be more simpler to build the table in two parts then merge them together after the data has been collected?