ctcp Posted November 29, 2011 Share Posted November 29, 2011 Hello i whant to creat stats page for my website can sombady help me how can SELECT database id |user_id | site_id | date 1 | 2222 | 18 | 2011-11-28 06:10:06 select id COUNT(site_id ) from table WHERE date = ? i whant to select last 7 days from database and count site_id per day . Quote Link to comment https://forums.phpfreaks.com/topic/252028-php-stats-select-help/ Share on other sites More sharing options...
freelance84 Posted November 29, 2011 Share Posted November 29, 2011 There's load of tutorials on google. You can just use webalizer though, which if you are on a shared host will most likely be installed already. Quote Link to comment https://forums.phpfreaks.com/topic/252028-php-stats-select-help/#findComment-1292146 Share on other sites More sharing options...
ctcp Posted November 29, 2011 Author Share Posted November 29, 2011 stats for my app and not for user statistics.. Quote Link to comment https://forums.phpfreaks.com/topic/252028-php-stats-select-help/#findComment-1292158 Share on other sites More sharing options...
freelance84 Posted November 29, 2011 Share Posted November 29, 2011 have you googled it and tried any? Quote Link to comment https://forums.phpfreaks.com/topic/252028-php-stats-select-help/#findComment-1292192 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.