Reviewed
"; echo "
Students' Projects
    "; $project_joomla = mysql_query("SELECT jos_papers.paper_id AS paperid, jos_papers.paper_description AS description, jos_paper_types.type_description AS type, jos_employees.first_name AS firstname, jos_employees.last_name AS lastname FROM jos_papers, jos_paper_types, jos_employees, jos_employees_papers WHERE jos_papers.paper_status = 4 AND jos_papers.publish LIKE '%J%' AND jos_papers.paper_type = jos_paper_types.type_id AND jos_employees.employee_id = jos_employees_papers.employee_id AND jos_papers.paper_id = jos_employees_papers.paper_id ORDER BY jos_papers.end_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)) { $paper_id = $row['paperid']; $head = $row['description']; $type = $row['type']; $author_firstname = $row['firstname']; $author_lastname = $row['lastname']; $file_name = ""; if($row2 = mysql_fetch_array(mysql_query("SELECT jos_papers_uploads.file_name AS filename FROM jos_papers_uploads WHERE jos_papers_uploads.paper_id ='{$paper_id}' AND jos_papers_uploads.file_name LIKE '%.pdf'"))) { $file_name = $row2['filename']; } if (substr($file_name, -4) == ".pdf" || $file_name == "") { echo "
  • $head, $type, $author_firstname $author_lastname"; if(substr($file_name, -4) == ".pdf") {echo " (PDF)";} echo"
  • "; } } echo"
"; echo "
Other
"; zFooter() ?>