note 110181 added to function.date

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 ...... ---- Server IP: 69.147.83.199 Probable Submitter: 41.42.177.94 ---- Manual Page -- http://www.php.net/manual/en/function.date.php Edit -- https://master.php.net/note/edit/110181 Del: integrated -- https://master.php.net/note/delete/110181/integrated Del: useless -- https://master.php.net/note/delete/110181/useless Del: bad code -- https://master.php.net/note/delete/110181/bad+code Del: spam -- https://master.php.net/note/delete/110181/spam Del: non-english -- https://master.php.net/note/delete/110181/non-english Del: in docs -- https://master.php.net/note/delete/110181/in+docs Del: other reasons-- https://master.php.net/note/delete/110181 Reject -- https://master.php.net/note/reject/110181 Search -- https://master.php.net/manage/user-notes.php