Codeigniter join gives last id back





.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}







3















I want to have the id from my table 'device_id' but I keep getting the id from 'inventory' because it is the last join.



I have tried to look it up on the internet but could found a solution for Codeigniter.



$this->db->where('device_id', $this->input->get('device_id'));



$this->db->join('repair_components', 'repair_options.component_id = repair_components.id');



$this->db->join('products', 'repair_options.product_id = products.id');



$this->db->join('inventory', 'repair_options.product_id = inventory.product_id', 'left');



$query = $this->db->get('repair_options');

$this->data['options'] = $query->result();



print_r($this->data['options']);


I want the id from 'device_id' in my array '$this->data['options']'.






php mysql codeigniter







share|improve this question

























  • What is the error/issue?

    – Danish Ali
    Jan 4 at 17:39











  • The problem has nothing to do with joins. You don't actually ask for any columns from a table named 'device_id'. It would be easier to help if the structure of the tables was known.

    – DFriend
    Jan 4 at 18:00


















3















I want to have the id from my table 'device_id' but I keep getting the id from 'inventory' because it is the last join.



I have tried to look it up on the internet but could found a solution for Codeigniter.



$this->db->where('device_id', $this->input->get('device_id'));



$this->db->join('repair_components', 'repair_options.component_id = repair_components.id');



$this->db->join('products', 'repair_options.product_id = products.id');



$this->db->join('inventory', 'repair_options.product_id = inventory.product_id', 'left');



$query = $this->db->get('repair_options');

$this->data['options'] = $query->result();



print_r($this->data['options']);


I want the id from 'device_id' in my array '$this->data['options']'.






php mysql codeigniter







share|improve this question

























  • What is the error/issue?

    – Danish Ali
    Jan 4 at 17:39











  • The problem has nothing to do with joins. You don't actually ask for any columns from a table named 'device_id'. It would be easier to help if the structure of the tables was known.

    – DFriend
    Jan 4 at 18:00














3












3








3








I want to have the id from my table 'device_id' but I keep getting the id from 'inventory' because it is the last join.



I have tried to look it up on the internet but could found a solution for Codeigniter.



$this->db->where('device_id', $this->input->get('device_id'));



$this->db->join('repair_components', 'repair_options.component_id = repair_components.id');



$this->db->join('products', 'repair_options.product_id = products.id');



$this->db->join('inventory', 'repair_options.product_id = inventory.product_id', 'left');



$query = $this->db->get('repair_options');

$this->data['options'] = $query->result();



print_r($this->data['options']);


I want the id from 'device_id' in my array '$this->data['options']'.






php mysql codeigniter







share|improve this question
















I want to have the id from my table 'device_id' but I keep getting the id from 'inventory' because it is the last join.



I have tried to look it up on the internet but could found a solution for Codeigniter.



$this->db->where('device_id', $this->input->get('device_id'));



$this->db->join('repair_components', 'repair_options.component_id = repair_components.id');



$this->db->join('products', 'repair_options.product_id = products.id');



$this->db->join('inventory', 'repair_options.product_id = inventory.product_id', 'left');



$query = $this->db->get('repair_options');

$this->data['options'] = $query->result();



print_r($this->data['options']);


I want the id from 'device_id' in my array '$this->data['options']'.






php mysql codeigniter




php mysql codeigniter






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Jan 4 at 16:01









Alon Eitan

11.3k63953




11.3k63953










asked Jan 4 at 16:00









edsas apiedsas api

161




161













  • What is the error/issue?

    – Danish Ali
    Jan 4 at 17:39











  • The problem has nothing to do with joins. You don't actually ask for any columns from a table named 'device_id'. It would be easier to help if the structure of the tables was known.

    – DFriend
    Jan 4 at 18:00



















  • What is the error/issue?

    – Danish Ali
    Jan 4 at 17:39











  • The problem has nothing to do with joins. You don't actually ask for any columns from a table named 'device_id'. It would be easier to help if the structure of the tables was known.

    – DFriend
    Jan 4 at 18:00

















What is the error/issue?

– Danish Ali
Jan 4 at 17:39





What is the error/issue?

– Danish Ali
Jan 4 at 17:39













The problem has nothing to do with joins. You don't actually ask for any columns from a table named 'device_id'. It would be easier to help if the structure of the tables was known.

– DFriend
Jan 4 at 18:00





The problem has nothing to do with joins. You don't actually ask for any columns from a table named 'device_id'. It would be easier to help if the structure of the tables was known.

– DFriend
Jan 4 at 18:00












2 Answers
2






active

oldest

votes


















0














Give table name to column in where clause and also make sure $this->input->get('device_id') have value in it. 



$this->db->join('repair_components', 'repair_options.component_id = repair_components.id');

$this->db->join('products', 'repair_options.product_id = products.id');

$this->db->join('inventory', 'repair_options.product_id = inventory.product_id', 'left');

$this->db->where('table_name.device_id', $this->input->get('device_id'));

$query = $this->db->get('repair_options');

$this->data['options'] = $query->result();



print_r($this->data['options']);





share|improve this answer































    0














    Simple but tricky one. all you need to do some changes..



    $this->db->select('*,device_id.id as the_device_id');
    
$this->db->from('repair_options');
    
$this->db->where('device_id', $this->input->get('device_id'));
    

    
$this->db->join('repair_components', 'repair_options.component_id = repair_components.id');
    

    
$this->db->join('products', 'repair_options.product_id = products.id');
    

    
$this->db->join('inventory', 'repair_options.product_id = inventory.product_id', 'left');
    

    
$query = $this->db->get();
    
$this->data['options'] = $query->result();
    

    
print_r($this->data['options']);





    share|improve this answer
























      Your Answer






      StackExchange.ifUsing("editor", function () {
      StackExchange.using("externalEditor", function () {
      StackExchange.using("snippets", function () {
      StackExchange.snippets.init();
      });
      });
      }, "code-snippets");

      StackExchange.ready(function() {
      var channelOptions = {
      tags: "".split(" "),
      id: "1"
      };
      initTagRenderer("".split(" "), "".split(" "), channelOptions);

      StackExchange.using("externalEditor", function() {
      // Have to fire editor after snippets, if snippets enabled
      if (StackExchange.settings.snippets.snippetsEnabled) {
      StackExchange.using("snippets", function() {
      createEditor();
      });
      }
      else {
      createEditor();
      }
      });

      function createEditor() {
      StackExchange.prepareEditor({
      heartbeatType: 'answer',
      autoActivateHeartbeat: false,
      convertImagesToLinks: true,
      noModals: true,
      showLowRepImageUploadWarning: true,
      reputationToPostImages: 10,
      bindNavPrevention: true,
      postfix: "",
      imageUploader: {
      brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
      contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
      allowUrls: true
      },
      onDemand: true,
      discardSelector: ".discard-answer"
      ,immediatelyShowMarkdownHelp:true
      });


      }
      });














      draft saved

      draft discarded


















      StackExchange.ready(
      function () {
      StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54042330%2fcodeigniter-join-gives-last-id-back%23new-answer', 'question_page');
      }
      );

      Post as a guest















      Required, but never shown

























      2 Answers
      2






      active

      oldest

      votes








      2 Answers
      2






      active

      oldest

      votes









      active

      oldest

      votes






      active

      oldest

      votes









      0














      Give table name to column in where clause and also make sure $this->input->get('device_id') have value in it. 



      $this->db->join('repair_components', 'repair_options.component_id = repair_components.id');
      
$this->db->join('products', 'repair_options.product_id = products.id');
      
$this->db->join('inventory', 'repair_options.product_id = inventory.product_id', 'left');
      
$this->db->where('table_name.device_id', $this->input->get('device_id'));
      
$query = $this->db->get('repair_options');
      
$this->data['options'] = $query->result();
      

      
print_r($this->data['options']);





      share|improve this answer




























        0














        Give table name to column in where clause and also make sure $this->input->get('device_id') have value in it. 



        $this->db->join('repair_components', 'repair_options.component_id = repair_components.id');
        
$this->db->join('products', 'repair_options.product_id = products.id');
        
$this->db->join('inventory', 'repair_options.product_id = inventory.product_id', 'left');
        
$this->db->where('table_name.device_id', $this->input->get('device_id'));
        
$query = $this->db->get('repair_options');
        
$this->data['options'] = $query->result();
        

        
print_r($this->data['options']);





        share|improve this answer


























          0












          0








          0







          Give table name to column in where clause and also make sure $this->input->get('device_id') have value in it. 



          $this->db->join('repair_components', 'repair_options.component_id = repair_components.id');
          
$this->db->join('products', 'repair_options.product_id = products.id');
          
$this->db->join('inventory', 'repair_options.product_id = inventory.product_id', 'left');
          
$this->db->where('table_name.device_id', $this->input->get('device_id'));
          
$query = $this->db->get('repair_options');
          
$this->data['options'] = $query->result();
          

          
print_r($this->data['options']);





          share|improve this answer













          Give table name to column in where clause and also make sure $this->input->get('device_id') have value in it. 



          $this->db->join('repair_components', 'repair_options.component_id = repair_components.id');
          
$this->db->join('products', 'repair_options.product_id = products.id');
          
$this->db->join('inventory', 'repair_options.product_id = inventory.product_id', 'left');
          
$this->db->where('table_name.device_id', $this->input->get('device_id'));
          
$query = $this->db->get('repair_options');
          
$this->data['options'] = $query->result();
          

          
print_r($this->data['options']);






          share|improve this answer












          share|improve this answer



          share|improve this answer










          answered Jan 4 at 17:42









          Danish AliDanish Ali

          1,86831021




          1,86831021

























              0














              Simple but tricky one. all you need to do some changes..



              $this->db->select('*,device_id.id as the_device_id');
              
$this->db->from('repair_options');
              
$this->db->where('device_id', $this->input->get('device_id'));
              

              
$this->db->join('repair_components', 'repair_options.component_id = repair_components.id');
              

              
$this->db->join('products', 'repair_options.product_id = products.id');
              

              
$this->db->join('inventory', 'repair_options.product_id = inventory.product_id', 'left');
              

              
$query = $this->db->get();
              
$this->data['options'] = $query->result();
              

              
print_r($this->data['options']);





              share|improve this answer




























                0














                Simple but tricky one. all you need to do some changes..



                $this->db->select('*,device_id.id as the_device_id');
                
$this->db->from('repair_options');
                
$this->db->where('device_id', $this->input->get('device_id'));
                

                
$this->db->join('repair_components', 'repair_options.component_id = repair_components.id');
                

                
$this->db->join('products', 'repair_options.product_id = products.id');
                

                
$this->db->join('inventory', 'repair_options.product_id = inventory.product_id', 'left');
                

                
$query = $this->db->get();
                
$this->data['options'] = $query->result();
                

                
print_r($this->data['options']);





                share|improve this answer


























                  0












                  0








                  0







                  Simple but tricky one. all you need to do some changes..



                  $this->db->select('*,device_id.id as the_device_id');
                  
$this->db->from('repair_options');
                  
$this->db->where('device_id', $this->input->get('device_id'));
                  

                  
$this->db->join('repair_components', 'repair_options.component_id = repair_components.id');
                  

                  
$this->db->join('products', 'repair_options.product_id = products.id');
                  

                  
$this->db->join('inventory', 'repair_options.product_id = inventory.product_id', 'left');
                  

                  
$query = $this->db->get();
                  
$this->data['options'] = $query->result();
                  

                  
print_r($this->data['options']);





                  share|improve this answer













                  Simple but tricky one. all you need to do some changes..



                  $this->db->select('*,device_id.id as the_device_id');
                  
$this->db->from('repair_options');
                  
$this->db->where('device_id', $this->input->get('device_id'));
                  

                  
$this->db->join('repair_components', 'repair_options.component_id = repair_components.id');
                  

                  
$this->db->join('products', 'repair_options.product_id = products.id');
                  

                  
$this->db->join('inventory', 'repair_options.product_id = inventory.product_id', 'left');
                  

                  
$query = $this->db->get();
                  
$this->data['options'] = $query->result();
                  

                  
print_r($this->data['options']);






                  share|improve this answer












                  share|improve this answer



                  share|improve this answer










                  answered Jan 4 at 18:04









                  Masih AnsariMasih Ansari

                  3308




                  3308






























                      draft saved

                      draft discarded




















































                      Thanks for contributing an answer to Stack Overflow!


                      • Please be sure to answer the question. Provide details and share your research!

                      But avoid …



                      • Asking for help, clarification, or responding to other answers.

                      • Making statements based on opinion; back them up with references or personal experience.


                      To learn more, see our tips on writing great answers.




                      draft saved


                      draft discarded














                      StackExchange.ready(
                      function () {
                      StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54042330%2fcodeigniter-join-gives-last-id-back%23new-answer', 'question_page');
                      }
                      );

                      Post as a guest















                      Required, but never shown





















































                      Required, but never shown














                      Required, but never shown












                      Required, but never shown







                      Required, but never shown

































                      Required, but never shown














                      Required, but never shown












                      Required, but never shown







                      Required, but never shown







                      -

                      Popular posts from this blog

                      Monofisismo

                      Image
                      Monofisismo (do grego: monos - "único, singular" e physis - "natureza") é o ponto de vista cristológico que defende que, depois da união do divino e do humano na encarnação histórica, Jesus Cristo, como encarnação do Filho ou Verbo ( Logos ) de Deus, teria apenas uma única "natureza", a divina, e não uma síntese de ambas. O monofisismo é contraposto pelo diofisismo (ou "diafisismo"), que defende que Jesus preservou em si as duas naturezas. Historicamente, o monofisismo se refere primordialmente à posição dos que (especialmente no Egito e, em menor grau, na Síria) rejeitaram as decisões do Concílio de Calcedônia em 451 (o quarto concílio ecumênico). Os membros mais moderados entre eles, porém, defendem a teologia "miafisita", que se tornou a oficial para as Igrejas Ortodoxas Orientais. Muitos ortodoxos orientais, porém, rejeitam essa classificação, mesmo como um termo genérico, mas ele é amplamente utilizado na literatura históri...
                      Read more

                      Angular Downloading a file using contenturl with Basic Authentication

                      Image
                      0 I have a contentUrl when user clicks on that,file should be downloaded. If I try to browse the contentUrl in the browser it asks for Userid and password.I believe this is Basic Authentication.I dont want user to enter UserId and Password so I am passing it Authorization(Please see below code). Url looks some thing like this: http://XXX.XXX.XX.XXX:8080/flowable-rest/service/runtime/tasks/90875/attachments/90555/content let username : string = 'admin'; let pwd : string = 'test'; let headers = new Headers(); headers.set('Accept', 'text/json'); headers.append('Content-Type', 'application/json'); headers.set('Access-Control-Allow-Origin', '*'); headers.set('Access-Control-Allow-Methods','POST, GET, OPTIONS, PUT, DELETE'); head...
                      Read more

                      Olmecas

                      Image
                      Monumento 1, uma das quatro cabeças colossais encontradas em La Venta, com altura aproximada de 3 metros Olmecas é a designação do povo e da civilização que estiveram na origem da antiga cultura pré-colombiana da Mesoamérica e que se desenvolveram nas regiões tropicais do centro-sul do atual México durante o pré-clássico, próximo de onde hoje estão localizados os estados mexicanos de Veracruz e Tabasco, no Istmo de Tehuantepec, numa zona designada área nuclear olmeca. A cultura olmeca floresceu nesta região aproximadamente entre 1500 e 400 a.C., [ 1 ] e crê-se que tenha sido a civilização-mãe de todas as civilizações mesoamericanas que se desenvolveram posteriormente. [ 2 ] No entanto, desconhece-se a sua exacta filiação étnica, ainda que existam numerosas hipóteses colocadas para tentar resolver esta questão. O etnónimo olmeca foi cunhado pelos arqueólogos do século XX, e não devem confundir-se com os muito posteriores olmecas-xicalancas que ocuparam vários locais do México...
                      Read more