From d526decc4884710ae7fafe7aa5171e7f59b24292 Mon Sep 17 00:00:00 2001
From: jhunkeler <jhunkeler@c5b2fb0a-d05d-0410-98c8-828840a80ff6>
Date: Sun, 27 Dec 2009 15:44:57 +0000
Subject: MySQL -> MySQLi Fixed memory leaks after Fetching arrays Removed all
 while loops that interfaced with $db->Fetch() Rewrote RSS module Fixed syntax
 error in donations module Fixed link structure for news module Reverting to
 old page display method

git-svn-id: http://svn.3rd-infantry-division.org/testing/branches/Bayonet CMS v2@402 c5b2fb0a-d05d-0410-98c8-828840a80ff6
---
 navigation.php | 13 +++++++------
 1 file changed, 7 insertions(+), 6 deletions(-)

(limited to 'navigation.php')

diff --git a/navigation.php b/navigation.php
index ecf1236..5765712 100644
--- a/navigation.php
+++ b/navigation.php
@@ -14,10 +14,11 @@
 <?php
   
    	$result = $db->Query("SELECT * FROM `bayonet_navigation` ORDER BY `weight`");
- 	while(($row = $db->Fetch($result))!==false)
-	{
-		echo '<td>&nbsp;&nbsp;<a href="'.$row['link'].'">'.strtoUpper($row['title']).'</a>&nbsp;&nbsp;</td>';
-	}
-?>
+   	$nav = $db->Fetch($result);
+
+   	foreach ($nav as $link) {
+   	  echo '<td>&nbsp;&nbsp;<a href="' . str_replace('&', '&amp;', $link['link']) . '">' . strtoupper($link['title']) . '</a>&nbsp;&nbsp;</td>'; 
+   	}
+   	?>
 	</tr>
-</table>
\ No newline at end of file
+</table>
-- 
cgit