raygastje

temp.php

<?php
include("connect.php");
session_start();

$projecten_id = $_GET["projecten_id"];

$_SESSION["projecten_id"] = $projecten_id;

$projecten     = mysql_query("SELECT p.*, a.project_afbeeldingen, b.project_bestand FROM `projecten` AS p, `project_afbeeldingen` AS a, `project_bestanden` AS b WHERE `projecten_id` = $projecten_id AND a.item_id = p.item_id AND p.bestand_id = b.bestand_id");
if( !$projecten ) { echo sprintf( "Query failed; %s" , mysql_error()); }
while ($get = mysql_fetch_assoc($projecten)) {
    echo $get["project_titel"]."<br>";
    echo $get["project_langeomschrijving"]; 
}
/** overbodig op dit moment?!
*//*
$item_id = $_GET["item_id"];

$_SESSION["item_id"] = $item_id;

$projecten 	= mysql_query("SELECT * FROM `project_afbeeldingen` WHERE `item_id` = $item_id");
if( !$projecten ) { echo sprintf( "Query failed; %s" , mysql_error()); }
while ($get = mysql_fetch_assoc($projecten)) {
    echo $get["project_afbeeldingen"]."<br>";
}
*/