menwn Posted December 15, 2006 Share Posted December 15, 2006 Hi everyoneHere is my problem. I read the tutorial about FullText Index search engines on phpfreaks and manages to make a search engine thanks to it. The only problem is that I have two tables. One with the article titles, numbers and dates and another with the articles (their body text). I want to be able when a search is performed on the title the resulting titles to be a hyperlink to the body text of the article so by clicking the title to be able to read the article. I cannot figure out how to do this. I thout to use JOIN on the query but it didn't work. Both tables have a column called articleID.Any ideas would be great... thanksmenwn Link to comment https://forums.phpfreaks.com/topic/30751-mysqlphp-search-engine-link-data/ Share on other sites More sharing options...
fenway Posted December 16, 2006 Share Posted December 16, 2006 Make another table, and index whatever you need from all the tables. Link to comment https://forums.phpfreaks.com/topic/30751-mysqlphp-search-engine-link-data/#findComment-142124 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.