concatenate field names into one and return

[php_begins]

I have the following mysql query:

        $lead_query=$this->db->query(" 
	   SELECT `first_name`, `last_name` , `state` FROM leads WHERE `lead_id`='$lead_id'
	   "); 
	   $this->view->lead_query=$lead_query->fetchALL();

 

Now when I retrieve the above details  I need to return the first_name last_name together(separated as space) and the name of the key as client_name in the array.

 

I need it that way because when i return a json_encode($lead_query), I want to return the first_name.last_name as client_name.

[php_begins]

.i dont know how that attached file got uploaded there..

[Maq]

.i dont know how that attached file got uploaded there..

Deleted.

[php_begins]

	   $lead_query=$this->db->query(" 
	   SELECT CONCAT(`first_name`, ' ', `last_name`) AS `client_name` , `state` FROM leads WHERE `lead_id`='$lead_id'
	   "); 

 

The above worked for me.