Home / Gezinssituaties

 

gezinssituaties
 
 
0) { $sql = "SELECT * FROM situaties WHERE id = \"".$id."\" "; $result = mysql_query($sql) or die("Kan query niet uitvoeren"); $row = mysql_fetch_array($result); if ($row) { $titel = $row["titel"]; $forumid = $row["forumcatid"]; echo "

".$row["titel"]."

\"".$row["titel"]."\"

".str_replace("


", "

", $row["hoofdtekst"])."

\n\n"; } mysql_free_result($result); $lcid = $row["linkscatid"]; $sql = "SELECT * FROM situaties_items WHERE situatieid = \"".$id."\" ORDER BY soort ASC, toegevoegd DESC"; $result = mysql_query($sql) or die("Kan query niet uitvoeren"); $oldsoort = ""; while ($row = mysql_fetch_array($result)) { switch ($row["soort"]) { case "artikel": $sql = "SELECT titel, datum FROM artikelen WHERE id=".$row["itemid"]; $s = "artikel.php?id=".$row["itemid"]; break; case "boek": $sql = "SELECT onderwerp as titel, datum FROM forumberichten WHERE id=".$row["itemid"]; $s = "boeken.php?id=".$row["itemid"]; break; case "expert": $sql = "SELECT onderwerp as titel, datum FROM forumberichten WHERE id=".$row["itemid"]; $s = "expert.php?id=".$row["itemid"]; break; case "forumtopic": $sql = "SELECT onderwerp as titel, datum FROM forumberichten WHERE id=".$row["itemid"]; $s = "frm_psts.php?topicid=".$row["itemid"]; break; case "nieuws": $sql = "SELECT titel, datum FROM nieuws WHERE id=".$row["itemid"]; $s = "nieuws.php?id=".$row["itemid"]; break; case "reis": $sql = "SELECT titel FROM reizen WHERE id=".$row["itemid"]; $s = "reis.php?id=".$row["itemid"]; break; case "adres": $sql = "SELECT onderwerp as titel, datum FROM forumberichten WHERE id=".$row["itemid"]; $s = "adressen.php?id=".$row["itemid"]; break; case "weblog": $sql = "SELECT onderwerp as titel, datum FROM forumberichten WHERE id=".$row["itemid"]; $s = "weblog.php?id=".$row["itemid"]; break; } if ($row["soort"]!=$oldsoort) { echo "

\n

".$row["soort"]."

\n"; } $isql = $sql; $iresult = mysql_query($isql) or die("Kan iquery niet uitvoeren"); $irow = mysql_fetch_array($iresult); mysql_free_result($iresult); echo "".ucfirst($irow["titel"])."
\n"; $oldsoort = $row["soort"]; } mysql_free_result($result); echo "

\n

forum

\n
"; echo "

\n

links

\n"; $sql = "SELECT * FROM links WHERE catid = ".$lcid." AND validated='yes' ORDER BY id"; $result = mysql_query($sql) or die("Kan query niet uitvoeren"); $x=0; while ($row = mysql_fetch_array($result)) { $x++; echo "
".($row["recommended"]=="yes" ? "**TIP** " : "")."".ucfirst($row["titel"])."
".ucfirst($row["beschrijving"])."
".$row["url"]." - ".$row["hits"]." hits - toegevoegd op ".date("d-m-Y", $row["dateadd"])."

"; } mysql_free_result($result); } else { $sql = "SELECT * FROM situaties ORDER BY datum ASC"; $result = mysql_query($sql) or die("Kan query niet uitvoeren"); while ($row = mysql_fetch_array($result)) { echo "

".$row["titel"]."

\"".$row["titel"]."\"

".str_replace("


", "

", $row["inleiding"])."

"; } mysql_free_result($result); } ?>

 

   
   

Steun Stichting 1Ouder: bankrekeningnummer 341631892 o.v.v. donatie