"; $project_joomla = mysql_query("SELECT jos_papers.paper_id, jos_papers.paper_status, jos_papers.paper_description AS description, jos_papers.paper_article AS article, jos_papers.paper_type, jos_papers.publish, jos_paper_status.status_id, jos_paper_status.status_description AS state, jos_paper_types.type_id, jos_paper_types.type_description AS type, jos_papers.paper_date as date, jos_employees.first_name AS firstname, jos_employees.last_name AS lastname, jos_employees.email AS email FROM jos_papers, jos_paper_status, jos_paper_types, jos_employees, jos_tutors, jos_titles 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%' AND jos_papers.paper_status = 1 AND jos_tutors.employee_id = jos_employees.employee_id AND jos_tutors.paper_id = jos_papers.paper_id AND jos_paper_types.type_description LIKE '%Projekt%' ORDER BY paper_id DESC"); if (!$project_joomla) { die('Ung├╝ltige Abfrage: ' .mysql_error());} while ($row = mysql_fetch_array($project_joomla)) { $head = $row['description']; $abstract = $row['article']; $type = $row['type']; $date = date_mysql2german($row['date']); $mentor_firstname = $row['firstname']; $mentor_lastname = $row['lastname']; $mentor_email = $row['email']; echo ""; } echo "
Projektarbeiten

Weitere Themen gibt es im Robotik-Labor K002A bei Benjamin Staehle (staehle@hs-weingarten.de). Eine kurze Voranmeldung ist gern gesehen, aber nicht zwingend notwendig. Eigene Ideen sind ebenfalls sehr willkommen!

$head

$abstract

Typ: $type, ausgeschrieben seit: $date
Betreuer: $mentor_firstname $mentor_lastname, $mentor_email

"; $spiderVideoStr = "Laufroboter VIDEO (Roboter lernt laufen)
Laufroboter VIDEO (Roboter läuft)"; zFooter(array("imgs/gruppe.jpg", "imgs/spider.jpg"), array(null, null), array("Die Weingartener ZAFH-Mitarbeiter Tobias Fromm, Richard Cubek, Wolfgang Ertel, Joachim Feßler, Benjamin Stähle (hinten v.l.n.r.), Karl Glatz, Vien Ngo, Martin Bertsche (vorne).", $spiderVideoStr)) ?>