Home / Questions / 187280
Accepted
Eduardo
Asked: 2020-08-09 12:26:33 +0800 CST 2020-08-09 12:26:33 +0800 CST

How to add more conditions and parameters to a query joined using INNER JOIN?

  • 772

I have added new columns to my news table more_newsincluding the columns, language, type_cover.

When I WHERE c.active=?try to add a AND c.language=?but it shows me the following message: An error occurred in the query

$strSQL="SELECT
         c.title_category,
         GROUP_CONCAT(COALESCE(n.mini_title,''),'≠',COALESCE(n.url,'') SEPARATOR '|') data
         FROM category c 
         INNER JOIN news_more n ON c.id_category=n.id_category
         WHERE c.active=?
         GROUP BY c.id_category
         LIMIT 10";

I don't know if the procedure is adequate, I don't know how to work very well with joined tables, this procedure is born from the following answer & question .

I describe the structure of the tables:

Table:category

id_category   title_category    active
   1          PREMIER LEAGUE      1
   2          CUP AMERICA         1

Table:news_more

id_one_more_news   country region   language   id_category   active
      1                  global        es            1          1
      2                  global        es            1          1
      3                    co          en            1          1

So I need to weigh more conditions WHEREbetween them I want to show only the data that is in the English language taking data from the column language-> en.

If later you wish to apply other conditions, you can explain to me what the processes and changes to follow are.

php

1 Answers

  1. Best Answer

    In the example you gave, if you want to add another parameter you would do it like this:

    $strSQL="SELECT 
             c.title_category,
             GROUP_CONCAT(COALESCE(n.title,''),'≠',COALESCE(n.url,'') SEPARATOR '|') data
         FROM category_20180712 c 
             INNER JOIN one_more_news_20180712 n ON c.id_category=n.id_category
         WHERE c.active=? AND c.language=?
         GROUP BY c.id_category"; 
if($stmtcategory = $con->prepare($strSQL)){
    $stmtcategory->bind_param("is",$active,$language);
    • 2