include 'globalFunctions.php'; include_once("scripts/verbindung.php"); zHeader('ZAFH SERVICEROBOTER', 'imgs/hs-wgt.big.jpg', 'http://www.hs-weingarten.de'); echo "
Presse |
";
$project_joomla = mysql_query("SELECT jos_press_releases.press_id AS pressid, jos_press_releases.press_description AS description, jos_press_releases.press_article AS article FROM jos_press_releases ORDER BY press_date DESC");
//$project_joomla = mysql_query("SELECT * FROM jos_papers, jos_paper_status, jos_paper_types WHERE jos_papers.paper_status = jos_paper_status.status_id AND jos_papers.paper_type = jos_paper_types.type_id AND jos_papers.publish LIKE '%J%' ORDER BY paper_id DESC");
if (!$project_joomla) { die('Ungültige Abfrage: ' .mysql_error());}
while ($row = mysql_fetch_array($project_joomla))
{
$press_id = $row['pressid'];
$desc = $row['description'];
$art = $row['article'];
// Überschrift bauen
echo"$desc "; // Artikel, etwas unsicher, hier kann ja jeder Code stehen. echo"$art"; $press_link = mysql_query("SELECT jos_press_uploads.file_name AS filename, jos_press_uploads.upload_description AS description FROM jos_press_uploads WHERE jos_press_uploads.press_id ='{$press_id}' "); if (!$press_link) { die('Ungültige Abfrage: ' .mysql_error());} while($row2 = mysql_fetch_array($press_link)) { $file_name = $row2['filename']; $description = $row2['description']; // baue Link unter der Überschrift echo"$description "; } echo" "; } echo" |