php - CodeIgniter table class loops through db records 3 times - why? -


This is my admin code (using template classes for Colin Williams): 

  $ This - & gt; Load-> Library ('table'); $ Table ['record'] = $ this- & gt; Db- & gt; Get_where ('data', array ('category_1' = & gt; 'weight')); $ This- & gt; Template-> Write_view ('content', 'vw / weight_vw', $ table, TRUE);   
 and my view code:  
  & lt; Div class = "grid_16" & gt; & Lt ;? Php echo $ this- & gt; Table- & gt; Income ($ archive); ? & Gt; & Lt; / Div & gt;   
 What do I get  
  2 1 29 2011-01-01 10 Weight 4 1 29 2010-11-03 11 Weight 5 1 2 9 2011 -05-02 10 Weight 6 1 42 2011-07-11 23 Weight // Only recorded in the database is recorded here 1 2 1 2 9 01-01-01 10 Weight has been repeated twice here 4 1 29, 2010-11 -03 11 Weight 5 1 29 2011-05-02 10 Weight 6 1 42 2011-07-11 23 Weight 2 1 2 9 01-01-01 10 Weight 4 1 29 2010-11-03 11 Weight 5 1 2 9 2011-05 -02 10 Weight 6 1 42 2011-07-11 23 Weight   
 Why any thoughts are happening? None of my codes have any loop or anything in it.   
 
 
 use  
 to view dB queries  $ this- & Gt; Output-> Enable_profiler ()   
  
 Take a query and run it directly against your DB.  
 Most like it, you have bad in your database model.

Comments

Post a Comment