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;
}
?>