\"" . $rs["machine_name"] ."\",\n"; endwhile; $filecontents .= $shortlist . ");\n\n" . $longlist . ");"; //echo $filecontents; $fp = fopen ("$upl/booking-data/apparatur1.txt", "w"); fwrite($fp,$filecontents); // initiera databasen och gör den tillgänglig i $db $db=@pg_connect("host=localhost port=5432 dbname=www user=www password=ryt78hhG") OR die(""); ?> menyn "; } echo "

Internal

"; $sql = "SELECT text, url, id, artikelid FROM meny WHERE length(id)=6 AND id LIKE '046%' ORDER BY sortering, id"; $q2 = pg_exec($db,$sql); $firstmeny = true; while ($rs2 = pg_fetch_array($q2)) { echo "
\"\""; // kolla om menyvalet är valt och markera det i så fall if (substr($_GET["mid"],0,6)==$rs2["id"]) { $linktext = "" . $rs2["text"] . ""; $aktuell = true; } else { $linktext = $rs2["text"]; $aktuell = false; } echo ""; echo $linktext . "
"; $firstmeny = false; // skriv ut menyns tredje nivå if ($aktuell) { echo ""; $sql = "SELECT text, url, id, artikelid FROM meny WHERE substr(id,1,6) = '" . $rs2["id"] . "' and length(id)=9 ORDER BY sortering, id"; //echo $sql; $q3 = pg_exec($db,$sql); if (pg_numrows($q3)>0) { while ($rs3 = pg_fetch_array($q3)) { echo ""; //echo "
\"\""; echo ""; //echo $linktext . "
"; //$firstmeny = false; if (substr($_GET["mid"],0,9)==$rs3["id"]) { echo "".$rs3["text"].""; $idaktiv = $rs3["id"]; $visa4 = "japp"; } else { echo $rs3["text"]; $visa4 = false; } echo "
"; ### start nivå 4 ### if ($visa4=="japp") { echo ""; $sql = "SELECT text, url, id, artikelid FROM meny WHERE substr(id,1,9) = '$idaktiv' and length(id)=12 ORDER BY sortering, id"; //echo $sql; $q4 = pg_exec($db,$sql); if (pg_numrows($q4)>0) { while ($rs4 = pg_fetch_array($q4)) { echo ""; } } echo "
\"\""; echo ""; if (substr($_GET["mid"],0,12)==$rs4["id"]) { echo "".$rs4["text"].""; $visa5 = true; } else { echo $rs4["text"]; $visa5 = false; } echo "
"; echo "
"; } ### slut nivå 4 ### echo "
\n"; } } echo "
"; } echo "
"; ?>
Back to external web