[RESOLVED] query with OR in where clause

[dejawho]

SELECT * FROM table1, table2 WHERE table1.ID = '$ID' OR table2.ID = '$ID'

Only 1 table can get selected depending on the ID variable.

Example: if ID is 87 then table1 would be empty but table2 would have data.

As of now it is only pulling from table2, and if table2 is the empty table then it just selects the first row from table 2 and ignores table1 completely.

Any ideas?

[david8787]

I think using union would work in this situation. http://www.w3schools.com/SQl/sql_union.asp

[dejawho]

Yep, thats what I am trying to do.

Thanks