$tableName = "AK_Texts";
$query = "SELECT info FROM $tableName WHERE name='nieuws1' LIMIT 1";
$result = mysql_query ($query);
if($result){
$data = mysql_fetch_array($result);
$info1 = formatTxt($data[info]);
}
$query = "SELECT info FROM $tableName WHERE name='nieuws2' LIMIT 1";
$result = mysql_query ($query);
if($result){
$data = mysql_fetch_array($result);
$info2 = formatTxt($data[info]);
}
?>
$tableName = "AK_Texts";
$query = "SELECT info FROM $tableName WHERE name='fietsroute' LIMIT 1";
$result = mysql_query ($query);
$info = "";
if($result){
$data = mysql_fetch_array($result);
$info = formatTxt($data[info]);
}
?>
BEN- / PASSIEFWONINGEN
NIEUWBOUW
RENOVATIE
OPENBARE PROJECTEN
$tableName = "AK_Projecten";
$tableNameImages = "AK_ImagesProjecten";
$dir = "./_imgs/_db/projects/";
$category = "passief";
$query = "SELECT projID, titel FROM $tableName WHERE category='$category' AND publish=1 ORDER BY volgorde ASC";
$result = mysql_query ($query);
while ($data = mysql_fetch_array ($result)){
$projID = $data[projID];
$titel = strtoupper(formatTxt($data[titel]));
// thumb
$thumb = $dir.$projID."_thumb.jpg";
?>
} ?>
echo $titel; ?>
$category = "nieuwbouw";
$query = "SELECT projID, titel FROM $tableName WHERE category='$category' AND publish=1 ORDER BY volgorde ASC";
$result = mysql_query ($query);
while ($data = mysql_fetch_array ($result)){
$projID = $data[projID];
$titel = strtoupper(formatTxt($data[titel]));
// thumb
$thumb = $dir.$projID."_thumb.jpg";
?>
} ?>
echo $titel; ?>
$category = "renovatie";
$query = "SELECT projID, titel FROM $tableName WHERE category='$category' AND publish=1 ORDER BY volgorde ASC";
$result = mysql_query ($query);
while ($data = mysql_fetch_array ($result)){
$projID = $data[projID];
$titel = strtoupper(formatTxt($data[titel]));
// thumb
$thumb = $dir.$projID."_thumb.jpg";
?>
} ?>
echo $titel; ?>
$category = "openbaar";
$query = "SELECT projID, titel FROM $tableName WHERE category='$category' AND publish=1 ORDER BY volgorde ASC";
$result = mysql_query ($query);
while ($data = mysql_fetch_array ($result)){
$projID = $data[projID];
$titel = strtoupper(formatTxt($data[titel]));
// thumb
$thumb = $dir.$projID."_thumb.jpg";
?>
} ?>
echo $titel; ?>
$tableName = "AK_Texts";
$query = "SELECT info FROM $tableName WHERE name='visie' LIMIT 1";
$result = mysql_query ($query);
$data = mysql_fetch_array($result);
$info = formatTxt($data[info]);
$dir = "./_imgs/_db/visie/";
$img = $dir."visie.jpg";
$tableNameImages = "AK_Images";
$query = "SELECT width, height FROM $tableNameImages WHERE imgID=1 LIMIT 1";
$result = mysql_query ($query);
if($result){
$data = mysql_fetch_array($result);
$imgW = $data['width'];
$imgH = $data['height'];
}
?>
} ?>
echo $info; ?>
if (file_exists($img)){ ?>
$tableName = "AK_Team";
$tableNameImages = "AK_ImagesTeam";
$dir = "./_imgs/_db/team/";
$i = 0;
$query = "SELECT * FROM $tableName WHERE publish=1 ORDER BY volgorde ASC";
$result = mysql_query ($query);
while ($data = mysql_fetch_array ($result)){
$teamID = $data[teamID];
$info = nl2br(formatTxt($data[info]));
// img
$img = $dir.$teamID.".jpg";
$i++;
if($i==1){
$extra = "active";
} else {
$extra = "";
}
?>
if($i>1){ ?>
} ?>
} ?>
echo $info; ?>
$i = 0;
$query = "SELECT teamID, titel FROM $tableName WHERE publish=1 ORDER BY volgorde ASC";
$result = mysql_query ($query);
while ($data = mysql_fetch_array ($result)){
$teamID = $data[teamID];
$titel = strtoupper(formatTxt($data[titel]));
$i++;
if($i==1){
$extra = " active";
} else {
$extra = "";
}
?>
echo $titel; ?>
} ?>