PHP Fulltext search on two (2) tables
PHP FULLTEXT Search. How do I do a FULLTEXT Search on 2 tables?
$sql = "SELECT * FROM main, order WHERE MATCH(main.company, main.name, main.email, main.address, order.size, order.color, order.manufacturer)
AGAINST('$searchTerm' IN NATURAL LANGUAGE MODE)";ASKER
Here are the two tables
I need to fulltext a few fields in one of the tables but i need to search both of them.
main.sql
order_info--2-.sql
I need to fulltext a few fields in one of the tables but i need to search both of them.
main.sql
order_info--2-.sql
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Likely this will be sufficient for someone to assist you.