note 110181 rejected from function.date by tularis
| From: | tularis@php.net | Date: | Thu, 27 Sep 2012 17:41:48 +0000 |
| Subject: | note 110181 rejected from function.date by tularis | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-191045@lists.php.net to get a copy of this message | ||
Note Submitter: computerz_man at yahoo dot com
----
The Table Structre is
---------------------------------
CREATE TABLE
mytable (
userId int(11) NOT NULL,
url varchar(100) NOT NULL,
visit_date int(11) NOT NULL
);
INSERT INTO mytable VALUES(1,'homepage',1225540800);
# User 1 visited the url homepage on Nov 1, 2008
INSERT INTO mytable VALUES(2,'contact',1225886400);
# User 2 visited the url contact on Nov 5, 2008
INSERT INTO mytable VALUES(3,'contact',1225972800);
# User 3 visited the url contact on Nov 6, 2008
INSERT INTO mytable VALUES(4,'homepage',1228132800);
# User 4 visited the url homepage on Dec 1, 2008
--------------------------------
According to this table ... How can i get the total visit for yesterday and another query to get the
total visits today until execute the query ......