<?php

// anzahl der tage im monat

$motage = date("t", mktime(0,0,0,$monat,$tag,$jahr));



for ($y=1; $y <= $motage; $y++) {

	echo "<tr><td>";

	switch (date("w", mktime(0,0,0,$monat,$y,$jahr))) { 

case 0:		echo "So ";		break; 

case 1:		echo "Mo ";		break; 

case 2:		echo "Di ";		break; 

case 3:		echo "Mi ";		break; 

case 4:		echo "Do ";		break; 

case 5:		echo "Fr ";		break; 

case 6:		echo "Sa ";		break; 

	}



echo date("j", mktime(0,0,0,$monat,$y,$jahr));



// datenbankinhalt als array

$zeile = mysql_fetch_array($result);



	echo "</td><td>" . $zeile["location_1"] . "</td><td>" . $zeile["location_2"] . "</td><td>" . $zeile["location_3"] . "</td></tr>";

}

?>

$sql  = "SELECT * FROM datumtab";

$sql .= " WHERE Datum='".date("Y-m-d", mktime(0,0,0,$monat,$y,$jahr))) ."'";



$res   = mysql_query($sql);

$zeile = mysql_fetch_array($res);

echo $zeile['location_1'];

echo $zeile['location_2'];