Using CONCAT() in active record

[eluser]daniMichael[/eluser]
Hey TheFuzzy0ne,

Could you help me get my concat statement working, I couldn't find a solution using google, so I came here.

I need to concatenate first name and last name from the users table.

Code:

$this->db->query('SELECT DISTINCT(CONCAT(first_name," ", last_name)) as concat_first_last_name FROM '.$table_data['table_name']);

That works like a charm, obviously its just a straight sql query. This will work for me in one section of my application. But will need CONCAT in the $this->db->select() function due to dynamic-ness.

I'm trying:

Code:

$this->db->select("CONCAT('first_name', 'last_name')");

And basically a dozen different combinations of backticks, single quotes, double quotes, showing table names, etc. (I was just trying to get it working without the space between for now)

This is my first app using Code Igniter.
If you (or anyone else), could help me out this would greatly be appreciated.

Thanks