How to prevent multiple rows with the same column value in a CodeIgniter query [closed]

Question

Closed. This question needs details or clarity. It is not currently accepting answers.

Want to improve this question? As written, this question is lacking some of the information it needs to be answered. If the author adds details in comments, consider editing them into the question. Once there's sufficient detail to answer, vote to reopen the question.

Closed last month.

Improve this question

When I use this SQL, the result of mem_name (from the first table) is repeated a lot how can I prevent that?

$sql = "
    SELECT
        mc.mc_id,
        mc.mc_role,
        mc.mc_order,
        mc.mc_order IS NULL AS isnull,
        mem.*
    FROM
        $this->memberCatsTableName mc,
        $this->tableName mem 
    WHERE
        mc.cat_id=$cat_id
        $where
        AND mc.member_id=mem.mem_id
        or mem.mem_name='$mem_name'
    ORDER BY
        isnull ASC,
        mc.mc_order ASC
";      
$query = $this->db->query($sql);
return $query->result_array();

We do not have any details about your schema. We do not know what $where holds. Using comma-JOINs is not recommended because they can be over looked as JOINs. Injecting variables directly into SQL strings may be destabilizing or dangerous to your app. Your mix of AND and OR logic is likely to be problematic. If a GROUP BY clause is desired, we need to understand how to properly handle the aggregated values in other columns. — mickmackusa
– mickmackusa ♦, Commented Nov 3 at 20:06

mickmackusa · Accepted Answer · 2025-11-03 20:08:49Z

1

Here is a modified query:

$sql = "SELECT mc.mc_id,mc.mc_role,mc.mc_order,mc.mc_order IS NULL AS isnull, mem.*

        FROM $this->memberCatsTableName mc, $this->tableName mem

        WHERE mc.cat_id=$cat_id $where  AND mc.member_id=mem.mem_id or mem.mem_name='$mem_name' 
         
        Group by mem.mem_name 

        ORDER BY isnull ASC, mc.mc_order ASC";

$query = $this->db->query($sql);
return $query->result_array();

You can group by the query. Or you can also specify the join criteria.

edited Nov 3 at 20:08

mickmackusa♦

49.2k13 gold badges98 silver badges165 bronze badges

answered May 18, 2012 at 4:22

chhameed

4,4564 gold badges30 silver badges47 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

woozy · Accepted Answer · 2012-05-16 12:57:49Z

0

You have to specify a join criteria.

answered May 16, 2012 at 12:57

woozy

1481 silver badge7 bronze badges

Collectives™ on Stack Overflow

How to prevent multiple rows with the same column value in a CodeIgniter query [closed]

2 Answers 2

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Related