TERMINE

Seminare und Workshops
include('textparser.inc.php');
$cfg_hostname = "localhost";
$cfg_username = "web239";
$cfg_password = "Mb5j?s98";
$cfg_database = "usr_web239_1";
$conn = mysql_connect($cfg_hostname, $cfg_username, $cfg_password);
if(!$conn)
die("mysql connection failed");
if(!mysql_select_db($cfg_database, $conn))
die("mysql database selection failed");
$query = mysql_query("SELECT s.id as id, s.name as title, text_a, text_b, text_c, text_d, text_e, text_f FROM gwa_seminars s LEFT JOIN gwa_seminars_termins t ON s.id = t.seminar AND t.end_date >= curdate() GROUP BY t.seminar HAVING count(t.seminar) > 0 ORDER BY s.sort DESC, s.name DESC", $conn);
if(!$query)
die("mysql query failed");
for($i = mysql_num_rows($query); $i > 0; $i--) {
?>
|
|