RIGHT((now()-1000000),14) AND active='1' ORDER BY date_from ASC, type DESC"; // testing $query ="SELECT * FROM $tablename WHERE code='$code' AND active='1' ORDER BY date_from ASC, type DESC"; # echo $query; $db_abfrage=@mysql_query($query) or die ("
Database connection error! Please try again later."); //Aus Tabelle lesen while ($zeile=@mysql_fetch_array($db_abfrage)): $f_hour=substr($zeile["date_from"],8,2); $f_minute=substr($zeile["date_from"],10,2); $f_seconds=substr($zeile["date_from"],12,2); $f_year=substr($zeile["date_from"],0,4); $f_month=substr($zeile["date_from"],4,2); $f_day=substr($zeile["date_from"],6,2); $f_timestamp=(mktime($f_hour,$f_minute,$f_seconds,$f_month,$f_day,$f_year)); $t_hour=substr($zeile["date_to"],8,2); $t_minute=substr($zeile["date_to"],10,2); $t_seconds=substr($zeile["date_to"],12,2); $t_year=substr($zeile["date_to"],0,4); $t_month=substr($zeile["date_to"],4,2); $t_day=substr($zeile["date_to"],6,2); $t_timestamp=(mktime($t_hour,$t_minute,$t_seconds,$t_month,$t_day,$t_year)); $id=$zeile["id"]; $type=$zeile["type"]; $intro= ($zeile["intro"]); $title= ($zeile["title"]); $text= nl2br($zeile["text"]); $date_from= strftime("%A, %d %B %Y @ %H:%M",$f_timestamp); $date_to= strftime("%A, %d %B %Y, ca. %H:%M",$t_timestamp); $venue= nl2br($zeile["venue"]); $currency= ($zeile["currency"]); $cost= ($zeile["cost"]); $trainer= ($zeile["trainer"]); $contact= ($zeile["contact"]); $phone= ($zeile["phone"]); $email= ($zeile["email"]); $items++; require('inc/workshop_table.inc.php'); endwhile; @mysql_close(); if($items==0) { echo '