카운트 표시가 0 로 나옵니다. 정보
카운트 표시가 0 로 나옵니다.
본문
mysql 디비 내에는 업데이트가 잘 되는 듯 합니다 (아래 테이블 참조요)
근데 skin에서 보여주는 숫자는 죄다 0입니다.
즉, 어제 : 0 | 오늘 : 0 | 최대 : 0 | 전체 : 0
... 왜 이런건지..... ㅜㅜ
아래의4가지 쿼리를 날린 결과를 밑에 쭈욱 그대로 복사해 붙입니다.
mysql> select * from g4_visit;
mysql> select * from g4_visit_sum;
mysql> desc g4_visit;
mysql> desc g4_visit_sum;
mysql> select * from g4_visit;
+-------+-----------------+------------+----------+-----------------------------
--------------------------------+-----------------------------------------------
--------------------------------------------+
| vi_id | vi_ip | vi_date | vi_time | vi_referer
| vi_agent
|
+-------+-----------------+------------+----------+-----------------------------
--------------------------------+-----------------------------------------------
--------------------------------------------+
| 1 | 116.121.250.239 | 2008-08-08 | 18:43:38 |
| Mozilla/4.0 (compatible; MSIE 6.0; Windows NT
5.1; SV1; InfoPath.2) |
| 2 | 89.251.107.4 | 2008-08-23 | 13:19:05 | http://www.xxxx.net/bbs/
board.php?bo_table=test&wr_id=1 | Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US
; rv:1.7.5) Gecko/20050519 Netscape/8.0.1 |
| 3 | 61.247.221.42 | 2008-08-23 | 23:54:02 |
| Yeti/1.0 (+http://help.naver.com/robots/)
|
| 4 | 116.127.188.206 | 2008-08-24 | 01:07:20 | http://xxx.cafe24.com/
| Mozilla/4.0 (compatible; MSIE 6.0; Windows NT
5.1; SV1; InfoPath.2) |
| 5 | 66.249.73.15 | 2008-08-24 | 01:47:56 |
| Mozilla/5.0 (compatible; Googlebot/2.1; +http:
//www.google.com/bot.html) |
| 6 | 74.6.17.151 | 2008-08-24 | 14:36:00 |
| Mozilla/5.0 (compatible; Yahoo! Slurp; http://
help.yahoo.com/help/us/ysearch/slurp) |
| 7 | 66.249.73.15 | 2008-08-25 | 10:21:05 |
| Mozilla/5.0 (compatible; Googlebot/2.1; +http:
//www.google.com/bot.html) |
| 8 | 208.70.77.141 | 2008-08-25 | 13:14:55 | http://xxxx.net/bbs/boar
d.php?bo_table=pl_flash |
|
| 9 | 61.247.221.45 | 2008-08-25 | 20:24:16 |
| Yeti/1.0 (+http://help.naver.com/robots/)
|
| 10 | 87.67.140.195 | 2008-08-25 | 22:39:00 | http://www.xxxx.net/
| Mozilla/4.0 (compatible; MSIE 7.0; Windows NT
5.1; .NET CLR 1.1.4322; .NET CLR 2.0.50727) |
| 11 | 116.127.188.206 | 2008-08-25 | 22:54:28 | http://xxx.cafe24.com/
| Mozilla/4.0 (compatible; MSIE 6.0; Windows NT
5.1; SV1; InfoPath.2) |
| 12 | 208.70.77.141 | 2008-08-26 | 01:34:53 | http://xxxx.net/bbs/boar
d.php?bo_table=pl_flash |
|
| 13 | 66.249.73.15 | 2008-08-26 | 03:48:05 |
| Mozilla/5.0 (compatible; Googlebot/2.1; +http:
//www.google.com/bot.html) |
| 14 | 66.249.73.15 | 2008-08-27 | 00:25:52 |
| Mozilla/5.0 (compatible; Googlebot/2.1; +http:
//www.google.com/bot.html) |
| 15 | 208.70.77.141 | 2008-08-27 | 02:05:18 | http://xxxx.net/bbs/boar
d.php?bo_table=pl_flash |
|
| 16 | 61.247.221.44 | 2008-08-27 | 04:49:55 |
| Yeti/1.0 (NHN Corp.; http://help.naver.com/rob
ots/) |
| 17 | 116.127.188.206 | 2008-08-27 | 13:36:31 | http://xxx.cafe24.com/
| Mozilla/4.0 (compatible; MSIE 6.0; Windows NT
5.1; SV1; InfoPath.2) |
| 18 | 208.70.77.141 | 2008-08-28 | 04:30:56 | http://xxxx.net/bbs/boar
d.php?bo_table=pl_flash |
|
| 19 | 66.249.73.15 | 2008-08-29 | 03:08:45 |
| Mozilla/5.0 (compatible; Googlebot/2.1; +http:
//www.google.com/bot.html) |
| 20 | 208.70.77.141 | 2008-08-29 | 03:46:43 | http://xxxx.net/bbs/boar
d.php?bo_table=pl_flash |
|
| 21 | 65.55.209.117 | 2008-08-29 | 04:11:11 |
| msnbot/1.0 (+http://search.msn.com/msnbot.htm)
|
| 22 | 116.127.188.206 | 2008-08-29 | 17:46:30 | http://xxx.cafe24.com/
| Mozilla/4.0 (compatible; MSIE 6.0; Windows NT
5.1; SV1; InfoPath.2) |
| 23 | 208.70.77.141 | 2008-08-30 | 03:23:44 | http://xxxx.net/bbs/boar
d.php?bo_table=pl_flash |
|
| 24 | 66.249.72.143 | 2008-08-30 | 05:59:20 |
| Mozilla/5.0 (compatible; Googlebot/2.1; +http:
//www.google.com/bot.html) |
| 25 | 66.249.73.15 | 2008-08-30 | 07:32:39 |
| Mozilla/5.0 (compatible; Googlebot/2.1; +http:
//www.google.com/bot.html) |
| 26 | 116.127.188.206 | 2008-08-30 | 18:50:31 | http://xxx.cafe24.com/
| Mozilla/4.0 (compatible; MSIE 6.0; Windows NT
5.1; SV1; InfoPath.2) |
+-------+-----------------+------------+----------+-----------------------------
--------------------------------+-----------------------------------------------
--------------------------------------------+
26 rows in set (0.00 sec)
mysql> select * from g4_visit_sum;
+------------+----------+
| vs_date | vs_count |
+------------+----------+
| 2008-08-08 | 1 |
| 2008-08-23 | 2 |
| 2008-08-24 | 3 |
| 2008-08-25 | 5 |
| 2008-08-26 | 2 |
| 2008-08-27 | 4 |
| 2008-08-28 | 1 |
| 2008-08-29 | 4 |
| 2008-08-30 | 4 |
+------------+----------+
9 rows in set (0.00 sec)
mysql>
mysql> desc g4_visit;
+------------+--------------+------+-----+------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------+--------------+------+-----+------------+----------------+
| vi_id | int(11) | | PRI | NULL | auto_increment |
| vi_ip | varchar(255) | | MUL | | |
| vi_date | date | | MUL | 0000-00-00 | |
| vi_time | time | | | 00:00:00 | |
| vi_referer | text | | | | |
| vi_agent | varchar(255) | | | | |
+------------+--------------+------+-----+------------+----------------+
6 rows in set (0.00 sec)
mysql>
desc g4_visit_sum;
+----------+---------+------+-----+------------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------+---------+------+-----+------------+-------+
| vs_date | date | | PRI | 0000-00-00 | |
| vs_count | int(11) | | MUL | 0 | |
+----------+---------+------+-----+------------+-------+
2 rows in set (0.00 sec)
근데 skin에서 보여주는 숫자는 죄다 0입니다.
즉, 어제 : 0 | 오늘 : 0 | 최대 : 0 | 전체 : 0
... 왜 이런건지..... ㅜㅜ
아래의4가지 쿼리를 날린 결과를 밑에 쭈욱 그대로 복사해 붙입니다.
mysql> select * from g4_visit;
mysql> select * from g4_visit_sum;
mysql> desc g4_visit;
mysql> desc g4_visit_sum;
mysql> select * from g4_visit;
+-------+-----------------+------------+----------+-----------------------------
--------------------------------+-----------------------------------------------
--------------------------------------------+
| vi_id | vi_ip | vi_date | vi_time | vi_referer
| vi_agent
|
+-------+-----------------+------------+----------+-----------------------------
--------------------------------+-----------------------------------------------
--------------------------------------------+
| 1 | 116.121.250.239 | 2008-08-08 | 18:43:38 |
| Mozilla/4.0 (compatible; MSIE 6.0; Windows NT
5.1; SV1; InfoPath.2) |
| 2 | 89.251.107.4 | 2008-08-23 | 13:19:05 | http://www.xxxx.net/bbs/
board.php?bo_table=test&wr_id=1 | Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US
; rv:1.7.5) Gecko/20050519 Netscape/8.0.1 |
| 3 | 61.247.221.42 | 2008-08-23 | 23:54:02 |
| Yeti/1.0 (+http://help.naver.com/robots/)
|
| 4 | 116.127.188.206 | 2008-08-24 | 01:07:20 | http://xxx.cafe24.com/
| Mozilla/4.0 (compatible; MSIE 6.0; Windows NT
5.1; SV1; InfoPath.2) |
| 5 | 66.249.73.15 | 2008-08-24 | 01:47:56 |
| Mozilla/5.0 (compatible; Googlebot/2.1; +http:
//www.google.com/bot.html) |
| 6 | 74.6.17.151 | 2008-08-24 | 14:36:00 |
| Mozilla/5.0 (compatible; Yahoo! Slurp; http://
help.yahoo.com/help/us/ysearch/slurp) |
| 7 | 66.249.73.15 | 2008-08-25 | 10:21:05 |
| Mozilla/5.0 (compatible; Googlebot/2.1; +http:
//www.google.com/bot.html) |
| 8 | 208.70.77.141 | 2008-08-25 | 13:14:55 | http://xxxx.net/bbs/boar
d.php?bo_table=pl_flash |
|
| 9 | 61.247.221.45 | 2008-08-25 | 20:24:16 |
| Yeti/1.0 (+http://help.naver.com/robots/)
|
| 10 | 87.67.140.195 | 2008-08-25 | 22:39:00 | http://www.xxxx.net/
| Mozilla/4.0 (compatible; MSIE 7.0; Windows NT
5.1; .NET CLR 1.1.4322; .NET CLR 2.0.50727) |
| 11 | 116.127.188.206 | 2008-08-25 | 22:54:28 | http://xxx.cafe24.com/
| Mozilla/4.0 (compatible; MSIE 6.0; Windows NT
5.1; SV1; InfoPath.2) |
| 12 | 208.70.77.141 | 2008-08-26 | 01:34:53 | http://xxxx.net/bbs/boar
d.php?bo_table=pl_flash |
|
| 13 | 66.249.73.15 | 2008-08-26 | 03:48:05 |
| Mozilla/5.0 (compatible; Googlebot/2.1; +http:
//www.google.com/bot.html) |
| 14 | 66.249.73.15 | 2008-08-27 | 00:25:52 |
| Mozilla/5.0 (compatible; Googlebot/2.1; +http:
//www.google.com/bot.html) |
| 15 | 208.70.77.141 | 2008-08-27 | 02:05:18 | http://xxxx.net/bbs/boar
d.php?bo_table=pl_flash |
|
| 16 | 61.247.221.44 | 2008-08-27 | 04:49:55 |
| Yeti/1.0 (NHN Corp.; http://help.naver.com/rob
ots/) |
| 17 | 116.127.188.206 | 2008-08-27 | 13:36:31 | http://xxx.cafe24.com/
| Mozilla/4.0 (compatible; MSIE 6.0; Windows NT
5.1; SV1; InfoPath.2) |
| 18 | 208.70.77.141 | 2008-08-28 | 04:30:56 | http://xxxx.net/bbs/boar
d.php?bo_table=pl_flash |
|
| 19 | 66.249.73.15 | 2008-08-29 | 03:08:45 |
| Mozilla/5.0 (compatible; Googlebot/2.1; +http:
//www.google.com/bot.html) |
| 20 | 208.70.77.141 | 2008-08-29 | 03:46:43 | http://xxxx.net/bbs/boar
d.php?bo_table=pl_flash |
|
| 21 | 65.55.209.117 | 2008-08-29 | 04:11:11 |
| msnbot/1.0 (+http://search.msn.com/msnbot.htm)
|
| 22 | 116.127.188.206 | 2008-08-29 | 17:46:30 | http://xxx.cafe24.com/
| Mozilla/4.0 (compatible; MSIE 6.0; Windows NT
5.1; SV1; InfoPath.2) |
| 23 | 208.70.77.141 | 2008-08-30 | 03:23:44 | http://xxxx.net/bbs/boar
d.php?bo_table=pl_flash |
|
| 24 | 66.249.72.143 | 2008-08-30 | 05:59:20 |
| Mozilla/5.0 (compatible; Googlebot/2.1; +http:
//www.google.com/bot.html) |
| 25 | 66.249.73.15 | 2008-08-30 | 07:32:39 |
| Mozilla/5.0 (compatible; Googlebot/2.1; +http:
//www.google.com/bot.html) |
| 26 | 116.127.188.206 | 2008-08-30 | 18:50:31 | http://xxx.cafe24.com/
| Mozilla/4.0 (compatible; MSIE 6.0; Windows NT
5.1; SV1; InfoPath.2) |
+-------+-----------------+------------+----------+-----------------------------
--------------------------------+-----------------------------------------------
--------------------------------------------+
26 rows in set (0.00 sec)
mysql> select * from g4_visit_sum;
+------------+----------+
| vs_date | vs_count |
+------------+----------+
| 2008-08-08 | 1 |
| 2008-08-23 | 2 |
| 2008-08-24 | 3 |
| 2008-08-25 | 5 |
| 2008-08-26 | 2 |
| 2008-08-27 | 4 |
| 2008-08-28 | 1 |
| 2008-08-29 | 4 |
| 2008-08-30 | 4 |
+------------+----------+
9 rows in set (0.00 sec)
mysql>
mysql> desc g4_visit;
+------------+--------------+------+-----+------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------+--------------+------+-----+------------+----------------+
| vi_id | int(11) | | PRI | NULL | auto_increment |
| vi_ip | varchar(255) | | MUL | | |
| vi_date | date | | MUL | 0000-00-00 | |
| vi_time | time | | | 00:00:00 | |
| vi_referer | text | | | | |
| vi_agent | varchar(255) | | | | |
+------------+--------------+------+-----+------------+----------------+
6 rows in set (0.00 sec)
mysql>
desc g4_visit_sum;
+----------+---------+------+-----+------------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------+---------+------+-----+------------+-------+
| vs_date | date | | PRI | 0000-00-00 | |
| vs_count | int(11) | | MUL | 0 | |
+----------+---------+------+-----+------------+-------+
2 rows in set (0.00 sec)
댓글 전체
mysql> select * from g4_visit_sum;
+------------+----------+
| vs_date | vs_count |
+------------+----------+
| 2008-08-08 | 1 |
| 2008-08-23 | 2 |
| 2008-08-24 | 3 |
| 2008-08-25 | 5 |
| 2008-08-26 | 2 |
| 2008-08-27 | 4 |
| 2008-08-28 | 1 |
| 2008-08-29 | 4 |
| 2008-08-30 | 4 |
+------------+----------+
9 rows in set (0.00 sec)
일단은, 쿼리 내용으로 봐서, count는 있는데.
아마도, 그 스킨에,. 변수가 잘못 전달 된듯합니다.
받는 페이지에서, print_r($_POST) 해보세요.. 값이 오는 지,
오는 것 확인 했으면, 변수가 제대로 만들어 졌는 지도 확인. 하시면..
+------------+----------+
| vs_date | vs_count |
+------------+----------+
| 2008-08-08 | 1 |
| 2008-08-23 | 2 |
| 2008-08-24 | 3 |
| 2008-08-25 | 5 |
| 2008-08-26 | 2 |
| 2008-08-27 | 4 |
| 2008-08-28 | 1 |
| 2008-08-29 | 4 |
| 2008-08-30 | 4 |
+------------+----------+
9 rows in set (0.00 sec)
일단은, 쿼리 내용으로 봐서, count는 있는데.
아마도, 그 스킨에,. 변수가 잘못 전달 된듯합니다.
받는 페이지에서, print_r($_POST) 해보세요.. 값이 오는 지,
오는 것 확인 했으면, 변수가 제대로 만들어 졌는 지도 확인. 하시면..
