|
From: mdw c. <myd...@li...> - 2001-12-06 16:28:41
|
MyDynaWeb CVS committal
Author : sukria
Project : mydynaweb
Module : htdocs
Dir : mydynaweb/htdocs
Modified Files:
count.php
Log Message:
REFERER replaced by REFERRER
===================================================================
RCS file: /cvsroot/mydynaweb/mydynaweb/htdocs/count.php,v
retrieving revision 1.5
retrieving revision 1.6
diff -u -3 -r1.5 -r1.6
--- count.php 2001/11/26 22:56:54 1.5
+++ count.php 2001/12/06 16:28:40 1.6
@@ -184,11 +184,11 @@
*/
$today = date("Y-m-d");
- $sql = "select REFERERS.REF_ID, NB
- from REF_DAY, REFERERS
+ $sql = "select REFERRERS.REF_ID, NB
+ from REF_DAY, REFERRERS
where REF_DAY.DAY = '$today'
- and REF_DAY.REF_ID = REFERERS.REF_ID
- and REFERERS.REF_URL = '$REF'";
+ and REF_DAY.REF_ID = REFERRERS.REF_ID
+ and REFERRERS.REF_URL = '$REF'";
$rqt = new query($DBH);
$rqt->query($DBH, $sql) or send_sql_error($PHP_SELF, $sql, $rqt->error());
$row = $rqt->getrow();
@@ -198,7 +198,7 @@
{
// referer exists in the referer DB ?
$sql = "select REF_ID
- from REFERERS
+ from REFERRERS
where REF_URL='$REF'";
$rqt = new query($DBH);
$rqt->query($DBH, $sql) or send_sql_error($PHP_SELF, $sql, $rqt->error());
@@ -210,7 +210,7 @@
}
else // no, first time we see that referer !
{
- $sql = "insert into REFERERS
+ $sql = "insert into REFERRERS
(REF_URL) values ('$REF')";
$rqt = new query($DBH);
$rqt->query($DBH, $sql) or send_sql_error($PHP_SELF, $sql, $rqt->error());
|