⚠ In case you've missed it, we have migrated to our new website, with a brand new forum. For more details about the migration you can read our blog post for website migration. This is an archived forum. ⚠

  •     

profile picture

How I can run this query in grocery crud?



DandyJK

DandyJK
  • profile picture
  • Member

Posted 24 October 2013 - 20:02 PM

Hello, good day, Sorry for my bad English, I'm Spanish
How I can run this query in grocery crud?
select mcu.usuario,lin.celular
from mc_usuarios mcu,linea lin
where mcu.id!=lin.idusu

I need that every time I select a figure and finish choose to terminate the registration did not reappear se-lected the data that had previously when registering another tuple.

 

source code

 

 

public function linea()
    {
        try{

            $crud = new grocery_CRUD();

            $crud->set_theme('flexigrid');

            $crud->set_table('linea');

            
            $crud->set_subject('Linea');


            $crud->set_language('spanish');


            $crud->display_as('idusu','Usuario');
            $crud->set_subject('Linea');

            $crud->set_relation('idusu','mc_usuarios','usuario');

            $output = $crud->render();
            $this->_example_output($output);
        }catch(Exception $e){

            show_error($e->getMessage().' --- '.$e->getTraceAsString());
        }

}