Hey. There are three tables article (id, title, text), tags (id, alias, name), articleTag. The latter is an intermediate table. The third table is needed for filtering by tags and adding tags to the article. In article and tags there is an id field, in articleTag there is an articleID and tagID field. These three tables are related. So I filter them:

"SELECT * FROM `articleTag` AS aT LEFT JOIN `article` AS a ON(aT.articleID = a.id) WHERE aT.tagID = 1"

So I get all the articles where there is a tag with id = 1. Question: there is another alias field in the tags table (varchar, the name of the tag is only in English). Is there a way to, without changing the connection, do a search not by tagID (in the intermediate table) but by alias? Or somehow convert the query above from alias to id tags?

    1 answer 1

    like this:

     select a.* from article a join articleTag at on at.articleID = a.id join tags t on at.tagID = t.id where at.tagID = 1 or t.alias = 'your-alias'
    • Strange. Error - Uncaught Error: Call to a member function setFetchMode () on string. Points to $ articles-> setFetchMode (PDO :: FETCH_ASSOC); Maybe something in the function is wrong? public static function articleByTag ($ tagAlias ​​= false) {if ($ tagAlias) {$ pdo = connectDB :: getConnection (); $ articles = array (); $ articles = ("your SQL query version '"); $ articles-> setFetchMode (PDO :: FETCH_ASSOC); } return $ articles-> fetchAll (); } - Edward
    • I don't see where $ pdo-> query ("your version of SQL query '") - tcpack4