include("includes/inc.header.php");
if (isset($_GET['project_id']))
{
$id = $_GET['project_id'];
}
else
{
$SQL="select id from project where deleted=0 order by dateadded desc limit 0,1";
$SQL = mysql_query($SQL) or die(mysql_error());
$dbId = mysql_fetch_array($SQL);
$id = $dbId['id'];
//update
}
?>
Projecten
include("includes/inc.menu.php");
?>
$SQL = "select `id`, `name`, `dateadded` from `project` where `deleted`=0 order by `dateadded` desc";
$SQL = mysql_query($SQL) or die(mysql_error());
while ($dbProject = mysql_fetch_array($SQL))
{
echo "|
";
}
?>
- Projecten
|
if($id != "")
{
$SQL = "select `id`, `name`, `desc`, `dateadded` from `project` where `id`=".$id;
$SQL = mysql_query($SQL) or die(mysql_error());
$dbProject = mysql_fetch_array($SQL);
echo $dbProject['name'] . " ";
echo DateDecoder($dbProject['dateadded'],1) . "
";
echo $dbProject['desc'] . "
";
//$SQL = "select a.`img_id`, a.`or_name`, a.`size` from `img` a inner join `l_project_img` b on a.`img_id`=b.`img_id` where a.`deleted`=0 and b.project_id=" . $id;
//$SQL = mysql_query($SQL) or die(mysql_error());
//$i=0;
//while ($dbPhoto = mysql_fetch_array($SQL))
//{
// echo " ";
// if ($i==4){ echo " ";}
// $i++;
//}
}
else
{
echo "geen projecten gevonden";
}
?>
|
include("includes/inc.footer.php");
?>