подсчет входов и выходов

CREATE TABLE `news_out` (<br /> `out_id` int(11) unsigned NOT NULL auto_increment,<br /> `out_uid` int(11) NOT NULL,<br /> `out_name` varchar(25) NOT NULL,<br /> `out_ip` varchar(15) NOT NULL default '',<br /> `out_referer` varchar(255) NOT NULL default '',<br /> `out_news_id` int(11) NOT NULL,<br /> `out_date` datetime NOT NULL default '0000-00-00 00:00:00',<br /> PRIMARY KEY (`out_id`)<br /> ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=cp1251 AUTO_INCREMENT=2 ;<br /> <br /> -- <br /> -- Дамп данных таблицы `news_out`<br /> -- <br /> <br /> INSERT INTO `news_out` VALUES (1, 5, 'f.ru', '127.0.0.1', '', 4, '2009-09-03 12:43:09');

CREATE TABLE `news_hits` (<br /> `hits_id` int(11) unsigned NOT NULL auto_increment,<br /> `hits_uid` int(11) NOT NULL,<br /> `hits_name` varchar(25) NOT NULL,<br /> `hits_ip` varchar(15) NOT NULL default '',<br /> `hits_referer` varchar(255) NOT NULL default '',<br /> `hits_news_id` int(11) NOT NULL,<br /> `hits_date` datetime NOT NULL default '0000-00-00 00:00:00',<br /> PRIMARY KEY (`hits_id`)<br /> ) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=cp1251 AUTO_INCREMENT=9 ;<br /> <br /> -- <br /> -- Дамп данных таблицы `news_hits`<br /> -- <br /> <br /> INSERT INTO `news_hits` VALUES (1, 5, 'f.ru', '127.0.0.45', 'http://f.ru/index.php', 3, '0000-00-00 00:00:00');<br /> INSERT INTO `news_hits` VALUES (2, 5, 'f.ru', '127.0.0.45', 'http://f.ru/index.php', 3, '0000-00-00 00:00:00');<br /> INSERT INTO `news_hits` VALUES (3, 5, 'f.ru', '127.0.0.45', 'http://f.ru/index.php', 3, '2009-09-03 12:32:12');<br />

$id_sites = $_GET['sites'];<br /> $result = $db->sql_query("SELECT d.hits_id,d.hits_uid,UNIX_TIMESTAMP(d.hits_date) as formatted,<br /> c.out_id,c.out_uid,UNIX_TIMESTAMP(c.out_date) as formatted <br /> FROM ".$prefix."_hits AS d LEFT JOIN ".$prefix."_out AS c ON d.hits_uid=c.out_uid WHERE d.hits_uid = '$id_sites' and <br /> <br /> c.out_uid = '$id_sites'"); <br /> list($hits_id,$hits_uid,$hits_date,$out_id,$out_uid,$out_date) = $db->sql_fetchrow($result);<br /> echo"Входы $hits_id/$out_id<br>";