Edit History

On 5/7/2016 at 1:19 AM, nikmagnus said:

this work perfect for me thanks !!!

I have done the following:

 

Added:

$this->_select = '
addr.address1 AS `address`,

and lower down:

'state' => array( 
          'title' => $this->l('State')
       ),

then later:

 

$this->_join = '
LEFT JOIN `'._DB_PREFIX_.'address` go ON (a.`id_address_delivery` = go.`id_address`)

 

On 5/7/2016 at 1:19 AM, nikmagnus said:

this work perfect for me thanks !!!

I have done the following:

 

Added:

$this->_select = '
addr.address1 AS `address`,

and lower down:

'state' => array( 
          'title' => $this->l('State')
       ),

then later:

 

$this->_join = '
LEFT JOIN `'._DB_PREFIX_.'address` go ON (a.`id_address_delivery` = go.`id_address`)

 

On 5/7/2016 at 1:19 AM, nikmagnus said:

this work perfect for me thanks !!!

I have done the following:

 

Added:

$this->_select = '
addr.address1 AS `address`,

and lower down:

'state' => array( 
          'title' => $this->l('State')
       ),

then later:

 

$this->_join = '
LEFT JOIN `'._DB_PREFIX_.'address` go ON (a.`id_address_delivery` = go.`id_address`)

Im really not good at understanding MYSQL and php, and I just cant figure out how to Show the state name rather than just the ID. Any help?