php mit mysqliabfrage

header('Content-Type: text/html; charset=UTF-8');$datum = date("l");setlocale(LC_TIME, "de_DE.utf8");echo "Heute ist ";echo strftime("%A");




$db_link = mysqli_connect (                     "xx.db.1and1.com",                      "xx",                      "xx",                      "xx"                    );mysqli_set_charset( $db_link, 'utf8');				
//Abfrage if ( $datum == "Monday" ){$sql = "SELECT * FROM `wp_event_hours`left join wp_posts on event_id = ID where weekday_id = 2424 or weekday_id = 2425 or weekday_id = 2410 order by start";}elseif ($datum == "Tuesday"){$sql = "SELECT * FROM `wp_event_hours`left join wp_posts on event_id = ID where weekday_id = 2426 or weekday_id = 2427 or weekday_id = 2428 order by start";}elseif ($datum == "Wednesday"){$sql = "SELECT * FROM `wp_event_hours`left join wp_posts on event_id = ID where weekday_id = 2429 or weekday_id = 2430 or weekday_id = 2431 order by start";}elseif ($datum == "Thursday"){$sql = "SELECT * FROM `wp_event_hours`left join wp_posts on event_id = ID where weekday_id = 2432 or weekday_id = 2433 or weekday_id = 2434 order by start";}elseif ($datum == "Friday"){$sql = "SELECT * FROM `wp_event_hours`left join wp_posts on event_id = ID where weekday_id = 2435 order by start";}elseif ($datum == "Saturday"){$sql = "SELECT * FROM `wp_event_hours`left join wp_posts on event_id = ID where weekday_id = 2436 order by start";}else{$sql = "SELECT * FROM `wp_event_hours`left join wp_posts on event_id = ID where weekday_id = 2437 order by start";}  $db_erg = mysqli_query( $db_link, $sql );
if ( ! $db_erg ){  die('Ungültige Abfrage: ' . mysqli_error());} echo '<table border="0">';while ($zeile = mysqli_fetch_array( $db_erg, MYSQL_ASSOC)){	$startz= substr($zeile['start'],0,5);	$endz= substr($zeile['end'],0,5);  echo "<tr>";  echo "<td>". $startz . "</td>";  echo "<td>" .'-'. "</td>";  echo "<td>". $endz . "</td>";  echo "<td>". $zeile['post_title'] . "</td>";


  echo "</tr>";}echo "</table>"; mysqli_free_result( $db_erg );