Tourneeplan
include('dbconnect/dbconnect.inc.php');
$sql_select = mysql_db_query($dbname,"SELECT * FROM $t_tour ORDER BY dro_tour_id ASC");
$count = mysql_num_rows($sql_select);
if($count == 0)
{
echo"
keine aktuellen Termine eingetragen
";
}
else
{
echo"
";
echo"".$t_head1[$lan]." | ".$t_head2[$lan]." | ".$t_head3[$lan]." |
";
while($tour_array = mysql_fetch_array($sql_select))
{
$from = $tour_array['dro_tour_von'];
$to = $tour_array['dro_tour_bis'];
$event= $tour_array['dro_tour_event'];
$location = $tour_array['dro_tour_ort'];
if($from == $to)
{
$tourdate = $to;
}
else
{
$from_substring = substr($from,0,6);
$tourdate = $from_substring." - ".$to;
}
$date = date("d."."m."."Y");
//'################################ DATUMSVERGLEICH ########################################################
$current_date_day = date("d");
$current_date_month = date("m");
$current_date_year = date("Y");
$date_explode = explode(".",$to);
if($current_date_year <= $date_explode[2])
{
//######################################################## n�chstes jahr #####################################################
if($date_explode[2] == $current_date_year+1){$year_go='xxx';}
if($current_date_month <= $date_explode[1] || $year_go)
{
// echo "month
";
echo"
".$tourdate." |
".$event." |
".$location." |
";
}
}
unset($from,$to,$event,$location,$tourdate,$from_substring);
}
echo"
";
echo $disclaimer[$lan];
}
?>