HEX
Server: Microsoft-IIS/8.5
System: Windows NT YDAWBH120 6.3 build 9600 (Windows Server 2012 R2 Standard Edition) AMD64
User: tentjecom_web (0)
PHP: 7.4.14
Disabled: NONE
Upload Files
File: D:/HostingSpaces/SBogers45/smuldersinterieurprojecten.nl/wwwroot/pages/frontendFunctions.php
<?php

function getSubmenuListItems($linkname){
	
		//var output
		$output = '';
		
		//get info from database
		$query = 'SELECT p.id, p.title, p.description 
					FROM '.$linkname.' AS p, status AS s
					WHERE s.active = 1
					AND s.page = "'.$linkname.'"
					AND s.itemId = p.id
					ORDER BY p.itemOrder DESC';
		$result = mysql_query($query);
		
		$count = 0;
		
		while($record = mysql_fetch_assoc($result)){
			$itemId = $record['id'];
			$title = fromDatabase($record['title']);
			$description = fromDatabase($record['description']);
			
			$title = strtolower($title);
			//create link
			$subLinkname = linkname($title);
			$link = '/particuliere-'.$subLinkname.'/';
			
			//li
			$output .= '<li id="'.$itemId.'" ' ;
			//active?
			if($count == 0) $output .= 'class="active" ';
			//rest (number 2 in loadSubPage stands for particulier
			$output .= 'onclick="SWFAddress.setValue(\''.$link.'\'); loadSubPage(\''.$linkname.'\','.$itemId.',2);">'.$title.'</li>';
			
			$count++;
			
		}
	
		return $output;

}


?>