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"
"; zFooter() ?>