[SOLVED] MySQL organitzation problem and results question

[eluser]rogierb[/eluser]
use "SELECT fieldname as some_name_you_want_to_give_it"

Code:

$this->db->select('producto_descripcion.name as producto_descripcion_name,fabricante_descripcion.anem as fabricante_descripcion_name')

// echo $row->producto_descripcion_name;