I'm making a search engine, and I have the feature "Search the Entire Site". This will search all the tables in my database for whatever they are searching for..
Anyway, I'm having problems getting this to work. What query would I use to SELECT multiple tables and search them all?
I keep getting an error saying something like the content column is ambiguous. What does this mean?
I'm currently using a query that looks simiar to this:
SELECT * FROM misc, about WHERE LOWER(content) LIKE '%$wrd%'
Thanks for any help,
Andrew
Anyway, I'm having problems getting this to work. What query would I use to SELECT multiple tables and search them all?
I keep getting an error saying something like the content column is ambiguous. What does this mean?
I'm currently using a query that looks simiar to this:
SELECT * FROM misc, about WHERE LOWER(content) LIKE '%$wrd%'
Thanks for any help,
Andrew