Using a column from a JOINed table in a CONCAT() expression with CodeIgniter's query builder [duplicate]

Question

I'm using CodeIgniter and I'm having difficulty trying to figure this out.

So I have this query that includes a joined table, then I need the ua_number column from that joined table for concatenation for the image column. The ua_number returns a value no problem but when I append it to the concatenation, it doesn't work as planned.

Here's the code

$this->db
    ->select(" 
        p.promotion_id,
        p.partner_id,
        ps.ua_number AS ua_number,
        description,
        start_date,
        end_date,
        date_created,
        CONCAT('https://s3-ap-southeast-1.amazonaws.com/paychatph-assets/pcb_updates/promotions/', MD5(p.promotion_id), '/', (ps.ua_number), '.jpeg')  AS image
    ")
    ->from('promotions p')
    ->join('partners ps' , 'p.partner_id = ps.partner_id' , 'INNER');

If the dupe target doesn't resolve your issue, then we will need more Debugging Details. How doesn't it "work as planned"? is it returning NULL? Missing a portion? The entire query fails with an error? What is the rendered query? — mickmackusa
– mickmackusa ♦, Commented Nov 10 at 20:18

Johnny Twoknives Krisco · Accepted Answer · 2021-06-29 11:13:22Z

0

is the problem that in the concat statement you have a ' at the beginning and a " at the end? I would think they need to match inside a single statement.

answered Jun 29, 2021 at 11:13

Johnny Twoknives Krisco

115 bronze badges

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

Comments

portapipe · Accepted Answer · 2021-06-29 12:11:11Z

0

Have you tried to add a pa.ua_number, to your select fields list? Maybe renaming it as ua_number broke something.

answered Jun 29, 2021 at 12:11

portapipe

265 bronze badges

Collectives™ on Stack Overflow

Using a column from a JOINed table in a CONCAT() expression with CodeIgniter's query builder [duplicate]

2 Answers 2

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Linked

Related