| | |
Full-text search on two tables
Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
![]() |
Hi, I managed to use the full-text search on a single table (product) and would like to search two tables (product and article) simultaneously, when user enter a keyword. Can anyone help?
Thanks
Thanks
Ecommerce-Web-Store.com Building Your e-Business.
Have been wondering the same. I believe you can only do a full text search on selected fields within a single table. In the past when I was in dire need of this feature and didn't have time to experiment, I did a brute force method where I ran a full text search on one table, a second full text search on a second table, and then merged the resultsets.
Of course, you can do a full text search on the article table and left join in the product table (without searching it).
Of course, you can do a full text search on the article table and left join in the product table (without searching it).
em... interesting. I was thinking of storing results from both tables (separate full-text search as you mentioned) in array, then sort them based on their scores, and display them. Not sure this may cause a long delay... any thought?
Ecommerce-Web-Store.com Building Your e-Business.
![]() |
Similar Threads
- pagination and search (PHP)
- Seacrch text using php (PHP)
- php/mysql full text search help (PHP)
Other Threads in the PHP Forum
- Previous Thread: How to display chat request alert on the remote side
- Next Thread: How to install mysqli extension
| Thread Tools | Search this Thread |
apache api array beginner binary body broken buttons cakephp checkbox class cms code cron curl database date date/time display dynamic ebooks echo email error file files folder form forms function functions global google href htaccess html image include insert ip javascript joomla limit link list login mail mediawiki menu mlm msqli_multi_query multiple mycodeisbad mysql number oop parameter paypal pdf php phpincludeissue problem query radio random recourse recursion regex remote script search seo server sessions sms source sp space speed sql static subdomain syntax system table tag tutorial update upload url validator variable vbulletin video web webdesign white wordpress xml youtube







