SELECT COUNT(DISTINCT ip), COUNT(*), CONCAT(shref,href) FROM hit
GROUP BY 3
It is work, result is table with many record.
SELECT COUNT(*), CONCAT(shref, href) FROM hit
GROUP BY 2
But this query don't work.
#
# Table structure for table 'hit'
#
CREATE TABLE hit (
owner_id int(10) unsigned NOT NULL default '0',
it_date datetime default NULL,
href varchar(64) default NULL,
ip varchar(16) default NULL,
os varchar(32) default NULL,
browser varchar(32) default NULL,
version varchar(32) default NULL,
x int(10) unsigned default NULL,
y int(10) unsigned default NULL,
depth int(10) unsigned default NULL,
cookie enum('0','1') default '0',
java enum('0','1') default '0',
page varchar(255) default NULL,
frame enum('0','1') default '0',
js char(3) default '0',
shref varchar(255) default NULL,
spage varchar(255) default NULL
) TYPE=MyISAM;
--
[Разработка веб-сайтов и презентаций] [Создание локальных сетей и установка миниАТС]
http://itsoft.ru, (095) 916-89-51, 916-89-63, 8-902-631-54-19
С наилучшими пожеланиями,
Игорь Тарасов mailto:[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
