thanx for your answer and a BIG SORRY fo that i haven't replied it 'till yet - but i was moving.
I have experimented with your suggestions and with my code, and here is the (working) 'alpha release':
Code: Select all
<?php
function startOfWeek () {
$start = date("Y",mktime(0,0,0,date("n"),(date("j")-date("w")),date("Y")))."-".date("m",mktime(0,0,0,date("n"),(date("j")-date("w")),date("Y")))."-".date("d",mktime(0,0,0,date("n"),(date("j")-(date("w"))),date("Y")));
return $start;}
$start = startOfWeek();
function endOfWeek () {
$end = date("Y",mktime(23,59,59,date("n"),(date("j")+(5-date("w"))),date("Y")))."-".date("m",mktime(23,59,59,date("n"),(date("j")+(6-date("w"))),date("Y")))."-".date("d",mktime(23,59,59,date("n"),(date("j")+(5-date("w"))),date("Y")));
return $end;}
$end = endOfWeek();
$cw_01_syear = substr($start, 0, 4);
$cw_01_smonth = substr($start, 5, 2);
$cw_01_sday = substr($start, 8, 2);
$cw_01_eyear = substr($end, 0, 4);
$cw_01_emonth = substr($end, 5, 2);
$cw_01_eday = substr($end, 8, 2);
$rquery01 = "SELECT events.location, CONCAT(events.year,'/',events.month,'/',events.day) AS date, events.time, events.email INTO OUTFILE "/usr/local/Web/shared/tmp/cw_01.txt" FIELDS TERMINATED BY ';' LINES TERMINATED BY "\n" FROM events WHERE (events.day >= '$cw_01_sday' AND events.day <= '$cw_01_eday') AND (events.month >= '$cw_01_smonth' AND events.month <= '$cw_01_emonth') AND (events.year >= '$cw_01_syear' AND events.year <= '$cw_01_eyear') AND (events.location != '' AND events.location != '0') ORDER BY events.weekday ASC, events.day ASC, events.month ASC, events.year ASC, events.time ASC, events.location ASC";
$rerg01 = MYSQL_QUERY($rquery01) or die(mysql_error());
$sday02 = $cw_01_sday + 7;
$eday02 = $cw_01_eday + 7;
$start02 = date("Y-m-d", mktime (0,0,0,$cw_01_smonth,$sday02,$cw_01_syear));
$end02 = date("Y-m-d", mktime (23,59,59,$cw_01_emonth,$eday02,$cw_01_eyear));
$cw_02_syear = substr($start02, 0, 4);
$cw_02_smonth = substr($start02, 5, 2);
$cw_02_sday = substr($start02, 8, 2);
$cw_02_eyear = substr($end02, 0, 4);
$cw_02_emonth = substr($end02, 5, 2);
$cw_02_eday = substr($end02, 8, 2);
$rquery02 = "SELECT events.location, CONCAT(events.year,'/',events.month,'/',events.day) AS date, events.time, events.email INTO OUTFILE "/usr/local/Web/shared/tmp/cw_02.txt" FIELDS TERMINATED BY ';' LINES TERMINATED BY "\n" FROM events WHERE (events.day >= '$cw_02_sday' AND events.day <= '$cw_02_eday') AND (events.month >= '$cw_02_smonth' AND events.month <= '$cw_02_emonth') AND (events.year >= '$cw_02_syear' AND events.year <= '$cw_02_eyear') AND (events.location != '' AND events.location != '0') ORDER BY events.weekday ASC, events.day ASC, events.month ASC, events.year ASC, events.time ASC, events.location ASC";
$rerg02 = MYSQL_QUERY($rquery02) or die(mysql_error());
?>
This can be continued for week_03, week_04 etc. So far, my problem seems to be solved - until somebody has an idea to do it better, easier or more efficient ...
By the way, a question to feyd as moderator: how can a topic be flagged as "solved"?