$query = "SELECT iid, itemtitel, tekst FROM items WHERE status='1' AND sid='13' ORDER BY positie DESC LIMIT 1";
$result = mysql_query($query);
$x = 1;
while ($row = mysql_fetch_object($result)) {
echo "
$row->itemtitel
"; echo "$row->tekst
";
}
$query = "SELECT iid, itemtitel, tekst FROM items WHERE status='1' AND sid='11' ORDER BY positie DESC LIMIT 1";
$result = mysql_query($query);
while ($row = mysql_fetch_object($result)) {
echo "$row->itemtitel
"; echo "$row->tekst
";
}
?>
Sitemap
$query = "SELECT sid,subtitel,link FROM subonderwerpen WHERE status='1' ORDER BY positie ASC"; $result = mysql_query($query); while ($row = mysql_fetch_object($result)) { $mijnhoofdid = $row->sid; $mijntitel = $row->subtitel; $hoofdlink = $row->link; if(($mijnhoofdid!="11") and ($mijnhoofdid!="9")){ echo "- ";
echo "
- ".$mijntitel." "; if($mijnhoofdid=="10"){ $query2 = "SELECT id as iid, titel as itemtitel FROM product_categorie WHERE actief='1' ORDER BY positie ASC"; } else{ $query2 = "SELECT iid, itemtitel FROM items WHERE status='1' AND sid='".$mijnhoofdid."' ORDER BY positie"; } $result2 = mysql_query($query2); echo "
- ".$mijntitel2." "; } echo "
- ";
while ($row2 = mysql_fetch_object($result2)) {
$itemid = $row2->iid;
$mijntitel2 = $row2->itemtitel;
echo "