note 110181 rejected from function.date by tularis

From: 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 ......

« previous php.notes (#191045) next »