<div>
Thanks for the help, that works perfectly. 
 
Kind Regards, 
 
John
</div>

Thanks for the help, that works perfectly.

Kind Regards,

John

<div>
<div class="content wysiwyg-content">
Hi, 
 
I have a fulltext search on one of my tables but I want to also search on another table that is linked to another table (I know that doesn't make any sense yet) 
 
I have 3 tables 
 
tblblogarticle 
articleID 
posterName 
articleTitle 
articleContent 
 
tblarticletags 
articleID 
tagID 
 
tbltags 
tagID 
tagName 
 
I have a fulltext search running on the tblarticle table that looks like this: 
mysql_query('SELECT articleID, posterName, articleTitle, articleContent FROM tblblogarticle WHERE MATCH(articleTitle, articleContent) AGAINST (&quot;'.$phrase.'&quot;)); 
 
This is working ok, but I woud like to expand my search to include the article tags associated with each article. &nbsp;The link is each article has several entries in the tblarticletags table that stores the articleID and tagID fields. &nbsp;The tbltags table contains the tagID and tagName. &nbsp;I want to search on the tagName with reference back to the original article to display the correct search results. 
 
I guess I am going to have to use joins to do this, but am not sure how to construct it? &nbsp;Any advice is welcomed. 
 
Kind Regards, 
 
John
</div>
</div>

Hi,

I have a fulltext search on one of my tables but I want to also search on another table that is linked to another table (I know that doesn't make any sense yet)

I have 3 tables

tblblogarticle
articleID
posterName
articleTitle
articleContent

tblarticletags
articleID
tagID

tbltags
tagID
tagName

I have a fulltext search running on the tblarticle table that looks like this:
mysql_query('SELECT articleID, posterName, articleTitle, articleContent FROM tblblogarticle WHERE MATCH(articleTitle, articleContent) AGAINST ("'.$phrase.'"));

This is working ok, but I woud like to expand my search to include the article tags associated with each article.  The link is each article has several entries in the tblarticletags table that stores the articleID and tagID fields.  The tbltags table contains the tagID and tagName.  I want to search on the tagName with reference back to the original article to display the correct search results.

I guess I am going to have to use joins to do this, but am not sure how to construct it?  Any advice is welcomed.

Kind Regards,

John

MySQL fulltext search joining tables

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.