query multiple tables and i think my statement is wrong

tekhead2004 · Joined: 10 Oct 2008 Posts: 1

Hey all,

Ive been trying to put together a php page for the last couple weeks that does a query on multiple tables at 1 time, and returns the results from each. In other words, i put in a search, it searches all the tables, then returns the results from whatever tables it finds my data in. each table is extremely different from the other, and as is the data. Im pretty sure that its just my statement that is wrong. Here is my statement but I cant seem to get it working right. Any help would be greatly appreciated.

select 'table1' results from table1 where field1= '$var' or field2 = '$var'
union
select 'table2' results from table2 where field1 = '$var'
union
select 'table3' results from table3 where field1 = '$var'

$var is my search that is put in.

This is making me lose my mind. Please help

lostboy · Joined: 02 May 2004 Posts: 6033 Location: toronto, canada

select fieldname1, fieldname2 from table where fieldname = '$var'
union
select fieldname1, fieldname2 from table where fieldname = '$var'

Note that when you do this, you need to make sure that the fields in the union tables are of the same datatype as the first query