I am trying to use a search script i found online and i am having a problem with the query.
I am trying do a query from multi tables.
I have 12 tables, all have the same fields: name, phone etc.
each table is a different category of items: appliances, art etc..
how do i go through each table and look for the field name?
$value = "oven";
i tried "select * from table1, table2 where name = {$oven}"
It did not work.
Please help with some suggestions.
Thank you!