Select from 2 different tables
Posted: Sun Feb 21, 2010 2:06 pm
Hello,
I am creating a search function and would like this two work with 2 or more tables; Dog Catalog and portfolio in this example. What am I doing wrong here?
"SELECT * FROM portfolio, Dog Catalog WHERE
Dog Catalog.title LIKE '%$find%' or
portfolio.client LIKE '%$find%'";
I get errors whenever I try to echo a result.
Any help would be appreciated.
I am creating a search function and would like this two work with 2 or more tables; Dog Catalog and portfolio in this example. What am I doing wrong here?
"SELECT * FROM portfolio, Dog Catalog WHERE
Dog Catalog.title LIKE '%$find%' or
portfolio.client LIKE '%$find%'";
I get errors whenever I try to echo a result.
Any help would be appreciated.