tekhead2004 Posted October 10, 2008 Share Posted October 10, 2008 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. 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 Quote Link to comment Share on other sites More sharing options...
Barand Posted October 10, 2008 Share Posted October 10, 2008 http://dev.mysql.com/doc/refman/5.0/en/select.html Quote Link to comment Share on other sites More sharing options...
fenway Posted October 11, 2008 Share Posted October 11, 2008 Yeah, no valid syntax there. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.