Roberto Fabian Rosero Diaz

good afternoon to all of you

 

please help me with this problem:

 

in my controller I have the following query:

 

$this->db->select( 
             'df.id_proveedor, 
              df.id_estab, 
              df.no_factura, 
              df.generada, 
              df.vencimiento, 
              df.concepto, 
              df.descuento, 
              df.valor, 
              df.recibido, 
              df.fecha_elab, 
              dp.nom_dpto'); 
            $this->db->from('datos_factura df'); 
            $this->db->join('establecimientos es','df.id_estab = es.id'); 
            $this->db->join('ciudades ci','es.id_ciudad = ci.id_ciudad'); 
            $this->db->join('dptos dp','ci.id_dpto = dp.id_dpto'); 

            $query['sql']=$this->db->get();  

and sent him to the view in this way:

$this->load->view('facturas/FacturaView', $query);  

however, in the view I have a foreach loop, which is where I have to store the records that have the query, which put up, the foreach is this

foreach($sql as $row){ 
         .... 
         }  

 

precisely within that loop is the one to display the records in a table, that's what I'd like for you to please tell me:

 

How do I display records from that query in this loop?

good morning.

 

first clarify two things:

 

1. I am using a translator that can not speak English

2.I am using the codeigniter crud grocery.

 

I have this query with a join made ​​by active record:

    $this->db->select('dp.nom_dpto'); 
    $this->db->from('datos_factura df'); 
    $this->db->join('establecimientos es','df.id_estab = es.id'); 
    $this->db->join('ciudades ci','es.id_ciudad = ci.id_ciudad'); 
    $this->db->join('dptos dp','ci.id_dpto = dp.id_dpto');

this, obviously, to bring a field in another table and display it in the table generated by the grocery crud.

 

but when I go to the browser, and I want to edit one of the records get this error:

SELECT `dp`.`nom_dpto` FROM (`datos_factura` df, `datos_factura`) JOIN `establecimientos` es ON `df`.`id_estab` = `es`.`id` JOIN `ciudades` ci ON `es`.`id_ciudad` = `ci`.`id_ciudad` JOIN `dptos` dp ON `ci`.`id_dpto` = `dp`.`id_dpto` WHERE `id` = '15'

 

however, I discovered that this error is that after the WHERE in the following line: `id` = '15', you have to add the alias for the table that I am using words that would read: `df`.' id `= '15' then my real question is this:

 

How do I put that "alias" in id that is after the where?

 

take into account that, as I'm using codeigniter, this should be a process unlike any sql

 

thanks for your help

good morning

 

I have a question please help:

 

I have three tables that are:

invoices, cities, departments

 

in the table "invoices" I have these fields:

 

id (pk)

description

value

id_city (Table cities fk)

 

and Table "city" I have these fields:

 

id (pk)

NameCity

id_dpt (fk departments table)

 

and Table "departments":

 

id (pk)

NameDepartament

 

however, in the grocery crud controller, I'm standing on the table "invoices", I have two users: "admin" and "mauro" then the admin user will be entering fields in the table "invoices", including the "NameCity "that I bring to the table" cities ", I want the user" mauro "can see the records that I put the admin user, but this Signature: User, rather than viewing the" NameCity "I want to see the field "NameDepartament" departments table with the name of the respective department of the city to put the user "admin".

 

 

I would like you please explain how I could do this

 

sorry as I wrote the English, is to use a translator because I speak Spanish

 

thank you very much in advance