Hejsan
kan man lägga ihop följande sql rader ($day och $return) till en enda...
$day = mysql_query("SELECT city_activities.name, calendar.time, calendar.id FROM calendar LEFT OUTER JOIN city_activities ON calendar.name = city_activities.id WHERE calendar.returning = 0 AND calendar.city = ". $_COOKIE["admin"] ." AND calendar.date = '". date("Y-m-d", mktime(0, 0, 0, $_GET["m"], $_GET["d"], $_GET["y"])) ."' ORDER BY calendar.time, city_activities.name");
$return = mysql_query("SELECT city_activities.name, calendar.time, calendar.id FROM calendar LEFT OUTER JOIN city_activities ON calendar.name = city_activities.id WHERE calendar.returning = 1 AND calendar.city = ". $_COOKIE["admin"] ." AND calendar.return_day = ".date("w", mktime(0, 0, 0, $_GET["m"], $_GET["d"], $_GET["y"]))." AND '".date("Y-m-d", mktime(0, 0, 0, $_GET["m"], $_GET["d"], $_GET["y"]))."' <= calendar.return_to AND '".date("Y-m-d", mktime(0, 0, 0, $_GET["m"], $_GET["d"], $_GET["y"]))."' >= calendar.date ORDER BY calendar.time, city_activities.name");
Tack
/Arvid