[eluser]Unknown[/eluser]
I'm having a similar problem. The second call to the result->list_fields method returns an empty array. The full table version works fine. Here is the code and the output:
Code:
Code:
$query = $this->db->get($mytablename);
echo 'this is the first call on table results: <br />';
print_r($query->list_fields());
echo '<br />this is the second call on table results: <br />';
print_r($query->list_fields());
$query = $this->db->get('tad_keywords');
echo '<br />this is the first call on full table: <br />';
print_r($this->db->list_fields($mytablename));
echo '<br />this is the second call on full table: <br />';
print_r($query->list_fields($mytablename));
Output:
this is the first call on table results:
Array ( [0] => id [1] => keyword [2] => aliaslist [3] => campaign_id [4] => contentcat [5] => keypadalias [6] => datafeed_id )
this is the second call on table results:
Array ( )
this is the first call on full table:
Array ( [0] => id [1] => keyword [2] => aliaslist [3] => campaign_id [4] => contentcat [5] => keypadalias [6] => datafeed_id )
this is the second call on full table:
Array ( [0] => id [1] => keyword [2] => aliaslist [3] => campaign_id [4] => contentcat [5] => keypadalias [6] => datafeed_id )
For now, I'm just stuffing the results of the first call in a variable and using that for repeats.