I have this query which counts the number of hits per week. It gives the following results:
11/07/05 - 17/07/05 - 3410
04/07/05 - 10/07/05 - 5618
27/06/05 - 03/07/05 - 1966
What i want it to do is also count for the days 27th - 3Oth June. At the moment for the date "27/06/05 - 03/07/05" it only counts between "01/07/05 - 03/07/05"
how can i do that?
heres my query:
Code: Select all
<?php
$sql_dailycountP = "select DATE_FORMAT(DATE_SUB(h_date, INTERVAL WEEKDAY(h_date) DAY), \"%d/%m/%y\" ) AS start_of_week, DATE_FORMAT( DATE_SUB( DATE_ADD(h_date, INTERVAL 6 DAY ), INTERVAL WEEKDAY(h_date) DAY), \"%d/%m/%y\" ) AS end_of_week, DATE_FORMAT(h_date, \"%u %M %Y\") AS week, SUM(h_count) AS week_total,e.* FROM tbl_hitcounter e WHERE DATE_FORMAT(h_date, \"%M %Y\") = DATE_FORMAT(NOW(), \"%M %Y\") AND h_group_item='stagecoach' GROUP BY week ORDER BY week DESC";
?>11/07/05 - 17/07/05 - 3410
04/07/05 - 10/07/05 - 5618
27/06/05 - 03/07/05 - 1966
What i want it to do is also count for the days 27th - 3Oth June. At the moment for the date "27/06/05 - 03/07/05" it only counts between "01/07/05 - 03/07/05"
how can i do that?
heres my query:
Code: Select all
<?php
$sql_dailycountP = "e;select DATE_FORMAT(DATE_SUB(h_date, INTERVAL WEEKDAY(h_date) DAY), \"e;%d/%m/%y\"e; ) AS start_of_week, DATE_FORMAT( DATE_SUB( DATE_ADD(h_date, INTERVAL 6 DAY ), INTERVAL WEEKDAY(h_date) DAY), \"e;%d/%m/%y\"e; ) AS end_of_week, DATE_FORMAT(h_date, \"e;%u %M %Y\"e;) AS week, SUM(h_count) AS week_total,e.* FROM tbl_hitcounter e WHERE DATE_FORMAT(h_date,wing results:
11/07/05 - 17/07/05 - 3410
04/07/05 - 10/07/05 - 5618
27/06/05 - 03/07/05 - 1966
What i want it to do is also count for the days 27th - 3Oth June. At the moment for the date "27/06/05 - 03/07/05" it only counts between "01/07/05 - 03/07/05"
how can i do that?
heres my query:Code: Select all
<?php
$sql_dailycountP = "e;select DATE_FORMAT(DATE_SUB(h_date, INTERVAL WEEKDAY(h_date) DAY), \"e;%d/%m/%y\"e; ) AS start_of_week, DATE_FORMAT( DATE_SUB( DATE_ADD(h_date, INTERVAL 6 DAY ), INTERVAL WEEKDAY(h_date) DAY), \"e;%d/%m/%y\"e; ) AS end_of_week, DATE_FORMAT(h_date, \"e;%u %M %
04/07/05 - 10/07/05 - 5618
27/06/05 - 03/07/05 - 1966
What i want it to do is also count for the days 27th - 3Oth June. At the moment for the date "27/06/05 - 03/07/05" it only counts between "01/07/05 - 03/07/05"
how can i do that?
heres my query:Code: Select all
<?php
$sql_dailycountP = "e;select DATE_FORMAT(DATE_SUB(h_date, INTERVAL WEEKDAY(h_date) DAY), \"e;%d/%m/%y\"e; ) AS start_of_week, DATE_FORMAT( DATE_SUB( DATE_ADD(h_date, INTERVAL 6 DAY ), INTERVAL WEEKDAY(h_date) DAY), \"e;%d/%m/%y\"e; ) AS end_of_week, DATE_FORMAT(h_date, \"e;%u %M %Y\"e;) AS week, SUM(h_count) AS wee/05 - 3410
04/07/05 - 10/07/05 - 5618
27/06/05 - 03/07/05 - 1966
What i want it to do is also count for the days 27th - 3Oth June. At the moment for the date "27/06/05 - 03/07/05" it only counts between "01/07/05 - 03/07/05"
how can i do that?
heres my query:Code: Select all
<?php
$sql_dailycountP = "select DATE_FORMAT(DATE_SUB(h_date, INTERVAL WEEKDAY(h_date) DAY), \"%d/%m/%y\" ) AS start_of_week, DATE_FORMAT( DATE_SUB( DATE_ADD(h_date, INTERVAL 6 DAY ), INTERVAL WEEKDAY(h_datthis query which counts the number of hits per week. It gives the following results:
11/07/05 - 17/07/05 - 3410
04/07/05 - 10/07/05 - 5618
27/06/05 - 03/07/05 - 1966
What i want it to do is also count for the days 27th - 3Oth June. At the moment for the date "27/06/05 - 03/07/05" it only counts between "01/07/05 - 03/07/05"
how can i do that?
heres my query:Code: Select all
<?php
$sql_dailycountP = "e;select DATE_FORMAT(DATE_SUB(h_date, INTERVAL WEEKDAY(h_date) DAY), \"e;%d/%m/%y\"e; ) AS start_of_week, DATE_FORMAT( DATE_SUB( DATE_ADD(h_date, INTERVAL 6 DAY ), INTERVAL WEEKDAY(h_date) DAY), \"e;%d/%m/%y\"e; ) AS end_of_week, DATE_FORMAT(h_date, \"e;%u %M %Y\"e;) AS week, SUM(h_count) AS week_total,e.* FROM tbl_hitcounter e WHERE DATE_FORMAT(h_date, \"e;%M %Y\"e;) = DATE_FORMAT(NOW(), \"e;%M %Y\"e;) AND h_group_item='stagecoach' GROUP BY week ORDER BYthis query which counts the number of hits per week. It gives the following results:
11/07/05 - 17/07/05 - 3410
04/07/05 - 10/07/05 - 5618
27/06/05 - 03/07/05 - 1966
What i want it to do is also count for the days 27th - 3Oth June. At the moment for the date "27/06/05 - 03/07/05" it only counts between "01/07/05 - 03/07/05"
how can i do that?
heres my query:Code: Select all
<?php
$sql_dailycountP = "select DATE_FORMAT(DATE_SUB(h_date, INTERVAL WEEKDAY(h_date) DAY), \"%d/%m/%y\" ) AS start_of_week, DATE_FORMAT( DATE_SUB( DATE_ADD(h_date, INTERVAL 6 DAY ), INTERVAL WEEKDAY(h_date) DAY), \"%d/%m/%y\" ) AS end_of_week, DATE_FORMAT(h_date, \"%u %M %Y\") AS week, SUM(h_count) AS week_total,e.* FROM tbl_hitcounter e WHERE DATE_FORMAT(h_date, \"%M %Y\") = DATE_FORMAT(NOW(), \"%M %Y\") AND h_group_item='stagecoach' GROUP BY week ORDER BY week DESC";
?>?>
HERE DATE_FORMAT(h_date, \"%M %Y\") = DATE_FORMAT(NOW(), \"%M %Y\") AND h_group_item='stagecoach' GROUP BY week ORDER BY week DESC";
?>
owing results:
11/07/05 - 17/07/05 - 3410
04/07/05 - 10/07/05 - 5618
27/06/05 - 03/07/05 - 1966
What i want it to do is also count for the days 27th - 3Oth June. At the moment for the date "27/06/05 - 03/07/05" it only counts between "01/07/05 - 03/07/05"
how can i do that?
heres my query:
Code: Select all
<?php
$sql_dailycountP = "select DATE_FORMAT(DATE_SUB(h_date, INTERVAL WEEKDAY(h_date) DAY), \"%d/%m/%y\" ) AS start_of_week, DATE_FORMAT( DATE_SUB( DATE_ADD(h_date, INTERVAL 6 DAY ), INTERVAL WEEKDAY(h_date) DAY), \"%d/%m/%y\" ) AS end_of_week, DATE_FORMAT(h_date, \"%u %M %Y\") AS w/05 - 17/07/05 - 3410
04/07/05 - 10/07/05 - 5618
27/06/05 - 03/07/05 - 1966
What i want it to do is also count for the days 27th - 3Oth June. At the moment for the date "27/06/05 - 03/07/05" it only counts between "01/07/05 - 03/07/05"
how can i do that?
heres my query:Code: Select all
<?php
$sql_dailycountP = "select DATE_FORMAT(DATE_SUB(h_date, INTERVAL WEEKDAY(h_date) DAY), \"e;%d/%m/%y\"e; ) AS start_of_week, DATE_FORMAT( DATE_SUB( DATE_ADD(h_date, INTEits per week. It gives the following results:
11/07/05 - 17/07/05 - 3410
04/07/05 - 10/07/05 - 5618
27/06/05 - 03/07/05 - 1966
What i want it to do is also count for the days 27th - 3Oth June. At the moment for the date "27/06/05 - 03/07/05" it only counts between "01/07/05 - 03/07/05"
how can i do that?
heres my query:Code: Select all
<?php
$sql_dailycountP = "select DATE_FORMAT(DATE_SUB(h_date, INTERVAL WEEKDAY(h_date) DAY), \"%d/%m/%y\" ) AS start_of_week, DATE_FORMAT( DATE_SUB( DATE_ADD(h_date, INTERVAL 6 DAY ), INTERVAL WEEKDAY(h_date) DAY), \"%d/%m/%y\" ) AS end_of_week, DATE_FORMAT(h_date, \"%u %M %Y\") AS week, SUM(h_count) AS week_total,e.* FROM tbl_hitcounter e WHERE DATE_FORMAT(h_date, \"%M %Y\") = DATE_FORMAT(NOW(), \"%M %Y\") AND h_group_item='stagecoach' GROUP BY week ORDER BY week DESC";
?>What i want it to do is also count for the days 27th - 3Oth June. At the moment for the date "27/06/05 - 03/07/05" it only counts between "01/07/05 - 03/07/05"
how can i do that?
heres my query:
Code: Select all
<?php
$sql_dailycountP = "e;select DATE_FORMAT(DATE_SUB(h_date, INTERVAL WEEKDAY(h_date) DAY), \"e;%d/%m/%y\"e; ) AS start_of_week, DATE_FORMAT( DATE_SUB( DATE_ADD(h_date, INTERVAL 6 DAY ), INTERVAL WEEKDAY(h_date) DAY), \"e;%d/%m/%y\"e; ) AS end_of_week, DATE_FORMAT(h_date, \"e;%u %M %Y\"e;) AS week, SUM(h_count) AS week_total,e.* FROM tbl_hitcounter e WHERE DATE_FORMAT(h_date, \"e;%M %Y\"e;) = DATE_FORMAT(NOW(), \"e;%M %Y\"e;) AND h_group_item='stagecoach' GR
how can i do that?
heres my query:Code: Select all
<?php
$sql_dailycountP = "select DATE_FORMAT(DATE_SUB(h_date, INTERVAL WEEKDAY(h_date) DAY), \"%d/%m/%y\" ) AS start_of_week, DATE_FORMAT( DATE_SUB( DATE_ADD(h_date, INTERVAL 6 DAY ), INTERVAL WEEKDAY(h_date) DAY), \"%d/%m/%y\" ) AS end_of_week, DATE_FORMAT(h_date, \"%u %M %Y\") AS week, SUM(h_count) AS week_total,e.* FROM tbl_hitcounter e WHERE DATE_FORMAT(h_date, \"%M %Y\") = DATE_FORMAT(NOW(), \&ich counts the number of hits per week. It gives the following results:
11/07/05 - 17/07/05 - 3410
04/07/05 - 10/07/05 - 5618
27/06/05 - 03/07/05 - 1966
What i want it to do is also count for the days 27th - 3Oth June. At the moment for the date "27/06/05 - 03/07/05" it only counts between "01/07/05 - 03/07/05"
how can i do that?
heres my query:Code: Select all
<?php
$sql_dailycountP = "select DATE_FORMAT(DATE_SUB(h_date, INTERVAL WEEKDAY(h_date) DAY), \"%d/%m/%y\" ) AS start_of_week, DATE_FORMAT( DATE_SUB( DATE_ADD(h_date, INTERVAL 6 DAY ), INTERVAL WEEKDAY(h_date) DAY), \"%d/%m/%y\" ) AS end_of_week, DATE_FORMAT(h_date, \"%u %M %Y\") AS week, SUM(h_count) AS week_total,e.* FROM tbl_hitcounter e WHERE DATE_FORMAT(h_date, \"%M %Y\") = DATE_FORMAT(NOW(), \"%M %Y\") AND h_group_item='stagecoach' GROUP BY week ORDER BY week DESC";
?>how can i do that?
heres my query:
Code: Select all
<?php
$sql_dailycountP = "e;select DATE_FORMAT(DATE_SUB(h_date, INTERVAL WEEKDAY(h_date) DAY), \"e;%d/%m/%y\"e; ) AS start_of_week, DATE_FORMAT( DATE_SUB( DATE_ADD(h_date, INTERVAL 6 DAY ), INTERVAL WEEKDAY(h_date) DAY), \"e;%d/%m/%y\"e; ) AS end_of_week, DATE_FORMAT(h_date, \"e;%u %M %Y\"e;) AS week, SUM(h_count) AS week_total,e.* FROM tbl_hitcounter e WHERE DATE_FORMAT(h_date, \"e;%M %Y\"e;) = DATE_FORMAT(NOW(), \"e;%M %Y\"e;) AND h_group_item='stagecoach' GROUP BY week ORDER BY week DESC"e;;
?&g
heres my query:Code: Select all
<?php
$sql_dailycountP = "select DATE_FORMAT(DATE_SUB(h_date, INTERVAL WEEKDAY(h_date) DAY), \"%d/%m/%y\" ) AS start_of_week, DATE_FORMAT( DATE_SUB( DATE_ADD(h_date, INTERVAL 6 DAY ), INTERVAL WEEKDAY(h_date) DAY), \"%d/%m/%y\" ) AS end_of_week, DATE_FORMAT(h_date, \"%u %M %Y\") AS week, SUM(h_count) AS week_total,e.* FROM tbl_hitcounter e WHERE DATE_FORMAT(h_date, \"%M %Y\") = DATE_FORMAT(NOW(), \"%M %Y\") AND h_group_item='stagecoach' GROUP BY week ORDER BY week DESC";
?>?>
want it to do is also count for the days 27th - 3Oth June. At the moment for the date "27/06/05 - 03/07/05" it only counts between "01/07/05 - 03/07/05"
how can i do that?
heres my query:
Code: Select all
<?php
$sql_dailycountP = "select DATE_FORMAT(DATE_SUB(h_date, INTERVAL WEEKDAY(h_date) DAY), \"e;%d/%m/%y\"e; ) AS start_of_week, DATE_FORMAT( DATE_SUB( DATE_ADD(h_date, INTERVAL 6 DAY ), INTERVAL WEEKDAY(h_date) DAY), \"e;%d/%m/%y\"e; ) AS end_of_week, DATE_FORMAT(h_date, \"e;%u %M %Y\"e;) AS week, SUM(h_count) AS week_total,e.* FROM tbl_hitcounter e WHERE DATE_FORMAT(h_date, r the date "27/06/05 - 03/07/05" it only counts between "01/07/05 - 03/07/05"
how can i do that?
heres my query:Code: Select all
<?php
$sql_dailycountP = "select DATE_FORMAT(DATE_SUB(h_date, INTERVAL WEEKDAY(h_date) DAY), \"%d/%m/%y\" ) AS start_of_week, DATE_FORMAT( DATE_SUB( DATE_ADD(h_date, INTERVAL 6 DAY ), INTERVAL WEEKDAY(h_date) DAY), \"%d/%m/%y\" ) AS end_of_week, DATE_FORMAT(h_date, \"%u %M %Y\") AS week, SUM(h_count) AS week_total,e.* FROM tbl_hitcounter e WHERE DATE_FORMAT(h_date, \"%M %Y\") = DATE_FORMAT(NOW(), \"%Mstart_of_week, DATE_FORMAT( DATE_SUB( DATE_ADD(h_date, INTERVAL 6 DAY ), INTERVAL WEEKDAY(h_date) DAY), \"%d/%m/%y\" ) AS end_of_week, DATE_FORMAT(h_date, \"%u %M %Y\") AS week, SUM(h_count) AS week_total,e.* FROM tbl_hitcounter e WHERE DATE_FORMAT(h_date, \"%M %Y\") = DATE_FORMAT(NOW(), \"%M %Y\") AND h_group_item='stagecoach' GROUP BY week ORDER BY week DESC";
?>11/07/05 - 17/07/05 - 3410
04/07/05 - 10/07/05 - 5618
27/06/05 - 03/07/05 - 1966
What i want it to do is also count for the days 27th - 3Oth June. At the moment for the date "27/06/05 - 03/07/05" it only counts between "01/07/05 - 03/07/05"
how can i do that?
heres my query:
Code: Select all
<?php
$sql_dailycountP = "select DATE_FORMAT(DATE_SUB(h_date, INTERVAL WEEKDAY(h_date) DAY), \"%d/%m/%y\" ) AS start_of_week, DATE_FORMAT( DATE_SUB( DATE_ADD(h_date, INTERVAL 6 DAY ), INTERVAL WEEKDAY(h_date) DAY), \"%d/%m/%y\" ) AS end_of_week, DATE_FORMAT(h_date, \"%u %M %Y\") AS week, SUM(h_count) AS week_tomp;lt;?php
$sql_dailycountP = "select DATE_FORMAT(DATE_SUB(h_date, INTERVAL WEEKDAY(h_date) DAY), \"%d/%m/%y\" ) AS start_of_week, DATE_FORMAT( DATE_SUB( DATE_ADD(h_date, INTERVAL 6 DAY ), INTERVAL WEEKDAY(h_date) DAY), \"%d/%m/%y\" ) AS end_of_week, DATE_FORMAT(h_date, \"%u %M %Y\") AS week, SUM(h_count) AS week_total,e.* FROM tbl_hitcounter e WHERE DATE_FORMAT(h_date, \"%M %Y\") = DATE_FORMAT(NOW(), \"%M %Y\") AND h_group_item='stagecoach' GROUP BY week ORDER BY week DESC";
?>11/07/05 - 17/07/05 - 3410
04/07/05 - 10/07/05 - 5618
27/06/05 - 03/07/05 - 1966
What i want it to do is also count for the days 27th - 3Oth June. At the moment for the date "27/06/05 - 03/07/05" it only counts between "01/07/05 - 03/07/05"
how can i do that?
heres my query:
Code: Select all
<?php
$sql_dailycountP = "e;select DATE_FORMAT(DATE_SUB(h_date, INTERVAL WEEKDAY(h_date) DAY), \"e;%d/%m/%y\"e; ) AS start_of_week, DATE_FORMAT( DATE_SUB( DATE_ADD(h_date, INTERVAL 6 DAY ), INTERVAL WEEKDAY(h_date) DAY), \"e;%d/%m/%y\"e; ) AS end_of_week, DATE_FORMAT(h_date, \"e;%u %M %Y\"e;) AS week, SUM(h_count) AS week_total,e.* FROM tbl_hitcounter e WHERE DATE_FORMAT(h_date, \"e;%M %Y\"e;) = DATE_FORMAT(NOW(), \"e;%M %Y\"e;) AND h_group_item='stagecoach' GROUP BY week ORDER BY03/07/05 - 1966
What i want it to do is also count for the days 27th - 3Oth June. At the moment for the date "27/06/05 - 03/07/05" it only counts between "01/07/05 - 03/07/05"
how can i do that?
heres my query:Code: Select all
<?php
$sql_dailycountP = "select DATE_FORMAT(DATE_SUB(h_date, INTERVAL WEEKDAY(h_date) DAY), \"%d/%m/%y\" ) AS start_of_week, DATE_FORMAT( DATE_SUB( DATE_ADD(h_date, INTERVAL 6 DAY ), INTERVAL WEEKDAY(h_date) DAY), \"%d/%m/%y\" ) AS end_of_week, DATE_FORMAT(h_date, \"%u %M %Y\") AS week, SUM(h_count) AS week_total,e.* FROM tbl_hitcounter e WHERE DATE_FORMAT(h_date, \"%M %Y\") = DATE_FORMAT(NOW(), \"%M %Y\") AND h_group_item='stagecoach' GROUP BY week ORDER BY week DESC";
?>11/07/05 - 17/07/05 - 3410
04/07/05 - 10/07/05 - 5618
27/06/05 - 03/07/05 - 1966
What i want it to do is also count for the days 27th - 3Oth June. At the moment for the date "27/06/05 - 03/07/05" it only counts between "01/07/05 - 03/07/05"
how can i do that?
heres my query:
Code: Select all
<?php
$sql_dailycountP = "select DATE_FORMAT(DATE_SUB(h_date, INTERVAL WEEKDAY(h_date) DAY), \"e;%d/%m/%y\"e; ) AS start_of_week, DATE_FORMAT( DATE_SUB( DATE_ADD(h_date, INTERVAL 6 DAY ), INTERVAL WEEKDAY(h_date) DAY), \"e;%d/%m/%y\"e; ) AS end_of_week, DATE_FORMAT(h_date, \"e;%u %M %Y\"e;) AS week, SUM(h_count) AS week_totaount for the days 27th - 3Oth June. At the moment for the date "27/06/05 - 03/07/05" it only counts between "01/07/05 - 03/07/05"
how can i do that?
heres my query:Code: Select all
<?php
$sql_dailycountP = "select DATE_FORMAT(DATE_SUB(h_date, INTERVAL WEEKDAY(h_date) DAY), \"%d/%m/%y\"e; ) AS start_of_week, DATE_FORMAT( DATE_SUB( DATE_ADD(h_date, INTERVAL 6 DAY ), INTERVAL WEEKDAY(h_date) DAY), \"%d/%m/%y\" ) AS end_of_week, DATE_FORMAT(h_date, \"%u %M %Y\"at i want it to do is also count for the days 27th - 3Oth June. At the moment for the date "27/06/05 - 03/07/05" it only counts between "01/07/05 - 03/07/05"
how can i do that?
heres my query:Code: Select all
<?php
$sql_dailycountP = "select DATE_FORMAT(DATE_SUB(h_date, INTERVAL WEEKDAY(h_date) DAY), \"e;%d/%m/%y\"e; ) AS start_of_week, DATE_FORMAT( DATE_SUB( DATE_ADD(h_date, INTERVAL 6 DAY ), INTERVAL WEEKDAY(h_date) DAY), \"e;%d/%m/%y\"e; ) AS end_of_week, DATE_FORMAT(h_date, \"e;%u %M %Y\"e;) AS week, SUM(h_count) AS week_total,e.* FROM tbl_hitcounter e WHERE DATE_FORMAT(h_date, \"e;%M %Y\"e;) = DATE_FORMAT(NOW(), \"e;%M %Y\"e;) AND h_group_item='stage$sql_dailycountP = "select DATE_FORMAT(DATE_SUB(h_date, INTERVAL WEEKDAY(h_date) DAY), \"%d/%m/%y\"e; ) AS start_of_week, DATE_FORMAT( DATE_SUB( DATE_ADD(h_date, INTERVAL 6 DAY ), INTERVAL WEEKDAY(h_date) DAY), \"%d/%m/%y\" ) AS end_of_week, DATE_FORMAT(h_date, \"%u %M %Y\") AS week, SUM(h_count) AS week_total,e.* FROM tbl_hitcount3/07/05"
how can i do that?
heres my query:Code: Select all
<?php
$sql_dailycountP = "select DATE_FORMAT(DATE_SUB(h_date, INTERVAL WEEKDAY(h_date) DAY), \"%d/%m/%y\" ) AS start_of_week, DATE_FORMAT( DATE_SUB( DATE_ADD(h_date, INTERVAL 6 DAY ), INTERVAL WEEKDAY(h_date) DAY), \"%d/%m/%y\" ) AS end_of_week, DATE_FORMAT(h_date, \"%u %M %Y\") AS week, SUM(h_count) AS week_total,e.* FROM tbl_hitcounter e WHERE DATE_FORMAT(h_date, \11/07/05 - 17/07/05 - 3410
04/07/05 - 10/07/05 - 5618
27/06/05 - 03/07/05 - 1966
What i want it to do is also count for the days 27th - 3Oth June. At the moment for the date "27/06/05 - 03/07/05" it only counts between "01/07/05 - 03/07/05"
how can i do that?
heres my query:Code: Select all
<?php
$sql_dailycountP = "select DATE_FORMAT(DATE_SUB(h_date, INTERVAL WEEKDAY(h_date) DAY), \"%d/%m/%y\" ) AS start_of_week, DATE_FORMAT( DATE_SUB( DATE_ADD(h_date, INTERVAL 6 DAY ), INTERVAL WEEKDAY(h_date) DAY), \"%d/%m/%y\" ) AS end_of_week, DATE_FORMAT(h_date, \"%u %M %Y\") AS week, SUM(h_count) AS week_total,e.* FROM tbl_hitcounter e WHERE DATE_FORMAT(h_date, \"%M %Y\") = DATE_FORMAT(NOW(), \"%M %Y\") AND h_group_item='stagecoach' GROUP BY week ORDER BY week DESC";
?>11/07/05 - 17/07/05 - 3410
04/07/05 - 10/07/05 - 5618
27/06/05 - 03/07/05 - 1966
What i want it to do is also count for the days 27th - 3Oth June. At the moment for the date "27/06/05 - 03/07/05" it only counts between "01/07/05 - 03/07/05"
how can i do that?
heres my query:
Code: Select all
<?php
$sql_dailycountP = "select DATE_FORMAT(DATE_SUB(h_date, INTERVAL WEEKDAY(h_date) DAY), \"%d/%m/%y\" ) AS start_of_week, DATE_FORMAT( DATE_SUB( DATE_ADD(h_date, INTERVAL 6 DAY ), INTERVAL WEEKDAY(h_date) DAY), \"%d/%m/%y\" ) AS end_of_week, DATE_FORMAT(h_date, \"%u %M %Y\") AS week, SUM(h_count) AS week_total,e.* FROM tbl_hitcounter e WHERE DATE_FORMAT(h_date, \"%M %Y\") = DATE_FORMAT(NOW(), \"%M %Y\") AND h_group_item='stagecoach' GROUP BY week ORDER BY week DESC";
?>Code: Select all
<?php
$sql_dailycountP = "select DATE_FORMAT(DATE_SUB(h_date, INTERVAL WEEKDAY(h_date) DAY), \"%d/%m/%y\" ) AS start_of_week, DATE_FORMAT( DATE_SUB( DATE_ADD(h_date, INTERVAL 6 DAY ), INTERVAL WEEKDAY(h_date) DAY), \"e;%d/%m/%y\" ) AS end_of_week, DATE_FORMAT(h_date, \"%u %M %Y\"his query which counts the number of hits per week. It gives the following results:
11/07/05 - 17/07/05 - 3410
04/07/05 - 10/07/05 - 5618
27/06/05 - 03/07/05 - 1966
What i want it to do is also count for the days 27th - 3Oth June. At the moment for the date "27/06/05 - 03/07/05" it only counts between "01/07/05 - 03/07/05"
how can i do that?
heres my query:Code: Select all
<?php
$sql_dailycountP = "e;select DATE_FORMAT(DATE_SUB(h_date, INTERVAL WEEKDAY(h_date) DAY), \"e;%d/%m/%y\"e; ) AS start_of_week, DATE_FORMAT( DATE_SUB( DATE_ADD(h_date, INTERVAL 6 DAY ), INTERVAL WEEKDAY(h_date) DAY), \"e;%d/%m/%y\"e; ) AS end_of_week, DATE_FORMAT(h_date, \"e;%u %M %Y\"e;) AS week, SUM(h_count) AS week_total,e.* FROM tbl_hitcounter e WHERE DATE_FORMAT(h_date, \"e;%M %Y\"e;) = DATE_FORMAT(NOW(), \"e;%M %Y\"e;) AND h_group_item='stagecoach' GROUP
What i want it to do is also count for the days 27th - 3Oth June. At the moment for the date "27/06/05 - 03/07/05" it only counts between "01/07/05 - 03/07/05"
how can i do that?
heres my query:Code: Select all
<?php
$sql_dailycountP = "e;select DATE_FORMAT(DATE_SUB(h_date, INTERVAL WEEKDAY(h_date) DAY), \"e;%d/%m/%y\"e; ) AS start_of_week, DATE_FORMAT( DATE_SUB( DATE_ADD(h_date, INTERVAL 6 DAY ), INTERVAL WEEKDAY(h_datk. It gives the following results:
11/07/05 - 17/07/05 - 3410
04/07/05 - 10/07/05 - 5618
27/06/05 - 03/07/05 - 1966
What i want it to do is also count for the days 27th - 3Oth June. At the moment for the date "27/06/05 - 03/07/05" it only counts between "01/07/05 - 03/07/05"
how can i do that?
heres my query:Code: Select all
<?php
$sql_dailycountP = "e;select DATE_FORMAT(DATE_SUB(h_date, INTERVAL WEEKDAY(h_date) DAY), \"e;%d/%m/%y\"e; ) AS start_of_week, DATE_FORMAT( DATE_SUB( DATE_ADD(h_date, INTERVAL 6 DAY ), INTERVAL WEEKDAY(h_date) DAY), \"e;%d/%m/%y\"e; ) AS end_of_week, DATE_FORMAT(h_date, \"e;%u %M %Y\"e;) AS week, SUM(h_count) AS week_total,e.* FROM tbl_hitcounter e WHERE DATE_FORMAT(h_date, \"e;%M %Y\"e;) = DATE_FORMAT(NOW(), \"e;%M %Y\"e;) AND h_group_item='stagecoach' GROUP BY week ORDER BY week DESC"e;;
?>
[/php06/05 - 03/07/05 - 1966
What i want it to do is also count for the days 27th - 3Oth June. At the moment for the date "27/06/05 - 03/07/05" it only counts between "01/07/05 - 03/07/05"
how can i do that?
heres my query:Code: Select all
<?php
$sql_dailycountP = "e;select DATE_FORMAT(DATE_SUB(h_date, INTERVAL WEEKDAY(h_date) DAY), \"%d/%m/%y\" ) AS start_of_week, DATE_FORMAT( DATE_SUB( DATE_ADD(h_date, INTERVAL 6 DAY ), INTERVAL WEEKDAY(h_date) DAY), \"%d/%m/%y\" ) AS end_of_week, DATE_FORMAT(h_date, \"%u %M %Y\") AS week, SUM(h_count) AS week_total,e.* FROM tbl_hitcounter e WHERE DATE_FORMAT(h_date, \"%M %Y\") = DATE_FORMAT(NOW(), \"%M %Y\") AND h_group_item='stagecoach' GROUP BY week ORDER BY week DESC";
?>11/07/05 - 17/07/05 - 3410
04/07/05 - 10/07/05 - 5618
27/06/05 - 03/07/05 - 1966
What i want it to do is also count for the days 27th - 3Oth June. At the moment for the date "27/06/05 - 03/07/05" it only counts between "01/07/05 - 03/07/05"
how can i do that?
heres my query:
Code: Select all
<?php
$sql_dailycountP = "e;select DATE_FORMAT(DATE_SUB(h_date, INTERVAL WEEKDAY(h_date) DAY), \"e;%d/%m/%y\"e; ) AS start_of_week, DATE_FORMAT( DATE_SUB( DATE_ADD(h_date, INTERVAL 6 DAY ), INTERVAL WEEKDAY(h_date) DAY), \"e;%d/%m/%y\"e; ) AS end_of_week, DATE_FORMAT(h_date, \"e;%u %M %Y\"e;) AS week, SUM(h_count) AS week_total,e.* FROM tbl_hitcounter e WHERE DATE_FORMAT(h_date, \"e;%M %Y\"e;) = DATE_FORM07/05 - 1966
What i want it to do is also count for the days 27th - 3Oth June. At the moment for the date "27/06/05 - 03/07/05" it only counts between "01/07/05 - 03/07/05"
how can i do that?
heres my query:Code: Select all
<?php
$sql_dailycountP = "e;select DATE_FORMAT(DATE_SUB(h_date, INTERVAL WEEKDAY(h_date) DAY), \"%d/%m/%y\" ) AS start_of_week, DATE_FORMAT( DATE_SUB( DATE_ADD(h_date, INTERVAL 6 DAY ), INTERVAL WEEKDAY(h_date) DAY), \"%d/%m/%y\" ) AS end_of_week, DATE_FORMAT(h_date, \"%u %M %Y\") AS week, SUM(h_count) AS week_total,e.* FROM tbl_hitcounter e WHERE DATE_5 - 5618
27/06/05 - 03/07/05 - 1966
What i want it to do is also count for the days 27th - 3Oth June. At the moment for the date "27/06/05 - 03/07/05" it only counts between "01/07/05 - 03/07/05"
how can i do that?
heres my query:Code: Select all
<?php
$sql_dailycountP = "select DATE_FORMAT(DATE_SUB(h_date, INTERVAL WEEKDAY(h_date) DAY), \"%d/%m/%y\" ) AS start_of_week, DATE_FORMAT( DATE_SUB( DATE_ADD(h_date, INTERVAL 6 DAY ), INTERVAL WEEKDAY(h_date) DAY), \"%d/%m/%y\" ) AS end_of_week, DATE_FORMAT(h_date, \"%u %M %Y\") AS week, SUM(h_count) AS week_total,e.* FROM tbl_hitcoFORMAT( DATE_SUB( DATE_ADD(h_date, INTERVAL 6 DAY ), INTERVAL WEEKDAY(h_date) DAY), \"%d/%m/%y\" ) AS end_of_week, DATE_FORMAT(h_date, \"%u %M %Y\") AS week, SUM(h_count) AS week_total,e.* FROM tbl_hitcounter e WHERE DATE_FORMAT(h_date, \"%M %Y\") = DATE_FORMAT(NOW(), \"%M %Y\") AND h_group_item='stagecoach' GROUP BY week ORDER BY week DESC";
?>Code: Select all
<?php
$sql_dailycountP = "select DATE_FORMAT(DATE_SUB(h_date, INTERVAL WEEKDAY(h_date) DAY), \"%d/%m/%y\" ) AS start_of_week, DATE_FORMAT( DATE_SUB( DATE_ADD(h_date, INTERVAL 6 DAY ), INTERVAL WEEKDAY(h_date) DAY), \"%d/%m/%y\" ) AS end_of_week, DATE_FORMAT(h_date, \"%u %M %Y\") AS week, SUM(h_count) AS week_total,e.* FROM tbl_hitcounter e WHERE DATE_FORMAT(h_date, \"%M %Y\") = DATE_FORMAT(NOW(), \"%M %Y\") AND h_group_item='stagecoach' GROUP BY week ORDER BY week DESC";
?>What i want it to do is also count for the days 27th - 3Oth June. At the moment for the date "27/06/05 - 03/07/05" it only counts between "01/07/05 - 03/07/05"
how can i do that?
heres my query:
Code: Select all
<?php
$sql_dailycountP = "select DATE_FORMAT(DATE_SUB(h_date, INTERVAL WEEKDAY(h_date) DAY), \"%d/%m/%y\" ) AS start_of_week, DATE_FORMAT( DATE_SUB( DATE_ADD(h_date, INTERVAL 6 DAY ), INTERVAL WEEKDAY(h_date) DAY), \"%d/%m/%y\" ) AS end_of_week, DATE_FORMAT(h_date, \"%u %M %Y\") AS week, SUM(h_count) AS week_total,e.* FROM tbl_hitcounter e WHERE DATE_FORMAT(h_date, \"%M %Y\") = DATE_FORMAT(NOW(), \"%M %Y\") AND h_group_item='stagecoach' GROUP BY week ORDER BY week DESC";
?>11/07/05 - 17/07/05 - 3410
04/07/05 - 10/07/05 - 5618
27/06/05 - 03/07/05 - 1966
What i want it to do is also count for the days 27th - 3Oth June. At the moment for the date "27/06/05 - 03/07/05" it only counts between "01/07/05 - 03/07/05"
how can i do that?
heres my query:
Code: Select all
<?php
$sql_dailycountP = "e;select DATE_FORMAT(DATE_SUB(h_date, INTERVAL WEEKDAY(h_date) DAY), \"e;%d/%m/%y\"e; ) AS start_of_week, DATE_FORMAT( DATE_SUB( DATE_ADD(h_date, INTERVAL 6 DAY ), INTERVAL WEEKDAY(h_date) DAY), \"e;%d/%m/%y\"e; ) AS end_of_week, DATE_FORMAT(h_date, \"e;%u %M %Y\"e;) AS week, SUM(h_count) AS week_total,e.* FROM tbl_hitcounter e WHERE DATE_FORMAT(h_date, \"e;%M %Y\"e;) = DATE_FORMAT(NOW(), \"e;%M %Y\"e;) AND h_group_item='stagecoach' GROUP BY week ORDER BY week DESC"e;;
?&he following results:
11/07/05 - 17/07/05 - 3410
04/07/05 - 10/07/05 - 5618
27/06/05 - 03/07/05 - 1966
What i want it to do is also count for the days 27th - 3Oth June. At the moment for the date "27/06/05 - 03/07/05" it only counts between "01/07/05 - 03/07/05"
how can i do that?
heres my query:Code: Select all
<?php
$sql_dailycountP = "e;select DATE_FORMAT(DATE_SUB(h_date, INTERVAL WEEKDAY(h_date) DAY), \"e;%d/%m/%y\"e; ) AS start_of_week, DATE_FORMAT( DATE_SUB( DATE_ADD(h_date, INTERVALthe number of hits per week. It gives the following results:
11/07/05 - 17/07/05 - 3410
04/07/05 - 10/07/05 - 5618
27/06/05 - 03/07/05 - 1966
What i want it to do is also count for the days 27th - 3Oth June. At the moment for the date "27/06/05 - 03/07/05" it only counts between "01/07/05 - 03/07/05"
how can i do that?
heres my query:Code: Select all
<?php
$sql_dailycountP = "select DATE_FORMAT(DATE_SUB(h_date, INTERVAL WEEKDAY(h_date) DAY), \"%d/%m/%y\" ) AS start_of_week, DATE_FORMAT( DATE_SUB( DATE_ADD(h_date, INTERVAL 6 DAY ), INTERVAL WEEKDAY(h_date) DAY), \"%d/%m/%y\" ) AS end_of_week, DATE_FORMAT(h_date, \"%u %M %Y\") AS week, SUM(h_count) AS week_total,e.* FROM tbl_hitcounter e WHERE DATE_FORMAT(h_date, \"%M %Y\") = DATE_FORMAT(NOW(), \"%M %Y\") AND h_group_item='stagecoach' GROUP BY week ORDER BY week DESC";
?>$sql_dailycountP = "select DATE_FORMAT(DATE_SUB(h_date, INTERVAL WEEKDAY(h_date) DAY), \"%d/%m/%y\" ) AS start_of_week, DATE_FORMAT( DATE_SUB( DATE_ADD(
27/06/05 - 03/07/05 - 1966
What i want it to do is also count for the days 27th - 3Oth June. At the moment for the date "27/06/05 - 03/07/05" it only counts between "01/07/05 - 03/07/05"
how can i do that?
heres my query:
Code: Select all
<?php
$sql_dailycountP = "e;select DATE_FORMAT(DATE_SUB(h_date, INTERVAL WEEKDAY(h_date) DAY), \"e;%d/%m/%y\"e; ) AS start_of_week, DATE_FORMAT( DATE_SUB( DATE_ADD(h_date, INTERVAL 6 DAY ), INTERVAL WEEKDAY(h_date) DAY), \"e;%d/%m/%y\"e; ) AS end_of_week, DATE_FORMAT(h_date, \"e;%u %M %Y\"e;) AS week, SUM(h_count) AS week_total,e.* FROM tbl_hitcounter e WHERE DATE_FORMAT(h_date, \"e;%M - 3410
04/07/05 - 10/07/05 - 5618
27/06/05 - 03/07/05 - 1966
What i want it to do is also count for the days 27th - 3Oth June. At the moment for the date "27/06/05 - 03/07/05" it only counts between "01/07/05 - 03/07/05"
how can i do that?
heres my query:Code: Select all
<?php
$sql_dailycountP = "select DATE_FORMAT(DATE_SUB(h_date, INTERVAL WEEKDAY(h_date) DAY), \"%d/%m/%y\" ) AS start_of_week, DATE_FORMAT( DATE_SUB( DATE_ADD(h_date, INTERVAL 6 DAY ), INTERVAL WEEKDAY(h_date) DAY), \"%d/%m/%y\" ) AS end_of_week, DATE_FORMAT(h_date, \"%u %M %Y\") AS week, SUM(h_count) AS week_total,e.* FROM tbl_hitcounter e WHERE DATE_FORMAT(h_date, \"%M %Y\") = DATE_FORMAT(NOW(), \"%M %Y\") AND h_group_item='stagecoach' GROUP BY week ORDER BY week DESC";
?>11/07/05 - 17/07/05 - 3410
04/07/05 - 10/07/05 - 5618
27/06/05 - 03/07/05 - 1966
What i want it to do is also count for the days 27th - 3Oth June. At the moment for the date "27/06/05 - 03/07/05" it only counts between "01/07/05 - 03/07/05"
how can i do that?
heres my query:
Code: Select all
<?php
$sql_dailycountP = "select DATE_FORMAT(DATE_SUB(h_date, INTERVAL WEEKDAY(h_date) DAY), \"%d/%m/%y\" ) AS start_of_week, DATE_FORMAT( DATE_SUB( DATE_ADD(h_date, INTERVAL 6 DAY ), INTERVAL WEEKDAY(h_date) DAY), \"%d/%m/%y\" ) AS end_of_week, DATE_FORMAT(h_date, \&q
27/06/05 - 03/07/05 - 1966
What i want it to do is also count for the days 27th - 3Oth June. At the moment for the date "27/06/05 - 03/07/05" it only counts between "01/07/05 - 03/07/05"
how can i do that?
heres my query:Code: Select all
<?php
$sql_dailycountP = "e;select DATE_FORMAT(DATE_SUB(h_date, INTERVAL WEEKDAY(h_date) DAY), \"e;%d/%m/%y\"e; ) AS start_of_week, DATE_FORMAT( DATE_SUB( DATE_ADD(h_date, INTERVAL 6 DAY ), INTERVAL WEEKDAY(h_date) DAY), \"e;%d/%m/%y\"e; ) AS end_of_week, DATE_FORMAT(h_date, \"e;%u %M %Y\"e;) AS week, SUM(h_count) AS week_total,e.* FROM tbl_hitcounter e WHERE DATE_FORMAT(h_daults:
11/07/05 - 17/07/05 - 3410
04/07/05 - 10/07/05 - 5618
27/06/05 - 03/07/05 - 1966
What i want it to do is also count for the days 27th - 3Oth June. At the moment for the date "27/06/05 - 03/07/05" it only counts between "01/07/05 - 03/07/05"
how can i do that?
heres my query:Code: Select all
<?php
$sql_dailycountP = "select DATE_FORMAT(DATE_SUB(h_date, INTERVAL WEEKDAY(h_date) DAY), \"%d/%m/%y\" ) AS start_of_week, DATE_FORMAT( DATE_SUB( DATE_ADD(h_date, INTERVAL 6 DAY ), INTERVAL WEEKDAY(h_date) DAY), \"%d/%m/%y\" ) AS end_of_week, DATE_FORMAT(h_date, \"%u %M %Y\") AS week, SUM(h_count) AS week_total,e.* FROM tbl_hitcounter e WHERE DATE_FORMAT(h_date, \"%M %Y\") = DATE_FORMAT(NOW(), \"%M %Y\") AND h_group_item='stagecoach' GROUP BY week ORDER BY week DESC";
?>$sql_dailycountP = "select DATE_FORMAT(DATE_SUB(h_date, INTERVAL WEEKDAY(h_date) DAY), \"%d/%m/%y\" ) AS start_of_week, DATE_FORMAT( DATE_SUB( DATE_ADD(h_date, INTERVAL 6 DAY ), INTERVAL WEEKDAY(h_date) DAY), \"%d/%m/%y\" ) AS end_of_week, DATE_FORMAT(h_date, \"%u %M %Y\") AS week, SUM(h_count) AS week_total,e.* FROM tbl_hitcounter e WHERE DATE_FORMAT(h_date, \"%M %Y\") = DATE_FORMAT(NOW(), \"%M %Y\") AND h_group_item='stagecoach' GROUP BY week ORDER BY week DESC";
?>