Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

Solved

Codeignitor Query

Posted on 2016-08-26

1 solution

Medium Priority

42 Views

Last Modified: 2016-09-09

I have a query that works but I need to add to it and I am not sure how. I need to pull two different fields.

Right now it looks like this

<?php
  SELECT
                CASE
                    WHEN o.business_type_id = 1 THEN o.first_name
                    WHEN o.business_type_id = 4 THEN o.legal_name 
                    ELSE o.business_name
                END

Open in new window

But I need to pull the First_Name and the Last_Name

Like this:

<?php
  SELECT
                ### Line 1 ###
                CASE
                    WHEN o.business_type_id = 1[b] THEN o.first_name AND .o.last_name[/b]
                    WHEN o.business_type_id = 4 THEN o.legal_name 
                    ELSE o.business_name
                END

Open in new window

Comment

Question by:rgranlund

[X]

Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

Help others & share knowledge
Earn cash & points
Learn & ask questions

Join The Community

1 Comment

LVL 41

Accepted Solution

by:Sharath

Sharath earned 2000 total points

ID: 417725522016-08-26

try if it supports CONCAT.

<?php
  SELECT
                CASE
                    WHEN o.business_type_id = 1 THEN CONCAT(o.first_name, o.last_name)
                    WHEN o.business_type_id = 4 THEN o.legal_name 
                    ELSE o.business_name
                END

Open in new window

Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Display your dates as Today, Yesterday etc in PHP

Article by: Gary

Build an array called $myWeek which will hold the array elements Today, Yesterday and then builds up the rest of the week by the name of the day going back 1 week. (CODE) (CODE) Then you just need to pass your date to the function. If i…

Keeping Secrets with PHP

Article by: Ray

Since pre-biblical times, humans have sought ways to keep secrets, and share the secrets selectively. This article explores the ways PHP can be used to hide and encrypt information.

Matching Tagged Data with PHP Regular Expressions

Video by: Terry

Learn how to match and substitute tagged data using PHP regular expressions. Demonstrated on Windows 7, but also applies to other operating systems. Demonstrated technique applies to PHP (all versions) and Firefox, but very similar techniques will w…