| von | bis | Ort | Objekt | Anmerkungen | Partner |
|---|
";
include_once("../php/write2db.php");
$con = mysql_connect($dbhost, $s_user, $s_pw) or die ("Verbindung gescheitert!");
mysql_select_db($db) or die ("Zugriff gescheitert!");
mysql_query("SET CHARACTER SET 'UTF8'");
$stmt = "SELECT DATE_FORMAT(start,'%d.%m.%Y') AS start_date,DATE_FORMAT(finished,'%d.%m.%Y') AS finished_date,city,object,customer,link,remarks FROM projects ORDER BY start DESC";
$recordSet = mysql_query($stmt);
while( $row = mysql_fetch_object($recordSet) ) {
echo "| "
.$row->start_date.
" | "
.$row->finished_date.
" | "
.$row->city.
" | ";
if($row->link != "") {
echo "".$row->object."";
}
else {
echo "$row->object";
}
echo " | "
.$row->remarks.
" | "
.$row->customer.
" |
";
}
echo "";
?>