Only getting first letter of each row :/

Only getting first letter of each row :/ - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: Only getting first letter of each row :/ (/showthread.php?tid=4036)

Only getting first letter of each row :/ - El Forum - 11-03-2007

[eluser]kevinprince[/eluser]
Hi,

Im having a small problem with some code I've written, for some reason when I do my foreach loop in the view, im only getting the first letter displaying of each row, and applying the foreach to the columns not the rows.

All very odd, heres the code extract:

Code:
$get_licences = $this->db->query("SELECT *  FROM `vk_licences` WHERE `gid` = '" . $gid . "'");

This is the the go get from DB bit

Code:
$member = array(

'licence' => $get_licences->row_array()

)

I add the row_array() into my view array

Code:
</tr>

&lt;?php foreach($licence as $item):?&gt;

<tr class="odd">

<td>&lt;?php echo $item['wkgb']; ?&gt;</td>

<td>&lt;?php echo $item['expiry']; ?&gt;</td>

</tr>

&lt;?php endforeach ?&gt;

The bit in the loop

Any help appreciated!

Only getting first letter of each row :/ - El Forum - 11-03-2007

[eluser]Phil Sturgeon[/eluser]
Use result_array() instead. You cant foreach a 1 dimensional array.

Only getting first letter of each row :/ - El Forum - 11-03-2007

[eluser]kevinprince[/eluser]
Wow, I just made a idiot out of myself!

Nice Spot!

Only getting first letter of each row :/ - El Forum - 11-04-2007

[eluser]Phil Sturgeon[/eluser]
Happens to us all. Run out of mountain dew/red bull/whiskey/etc? Wouldnt be the first time :p