I am trying to have a search bar where user will input a string ($var) which after i will search that sting in the field named: "itemname". i will search all the different tables in the database and create a new temporary database named: searchtable. seachtable should contain all the data where itemname was $var. Then i want to select the data from the new database and display it.
Sounds simple right? wrong! :) i am having issues.
here is my query statement:
$query = "Select * INTO searchtable from art WHERE itemname like \"%$trimmed%\" UNION ALL Select * INTO searchtable from cellphone WHERE itemname like \"%$trimmed%\"";
after when i try to select i do not get any data.
How long does a temporary table stays for?