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

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

_________________
Lostboy

Cat, the other other white meat

Please read Posting Etiquette before posting

You can always try Google