GoFuckYourself.com - Adult Webmaster Forum - View Single Post - PHP? Count number of times id shows up in 24 hours (based on timestamp)

livexxx · 05-29-2012, 06:12 PM

what about something like

SELECT UserName, Count(UserName) AS SumOfUses FROM table WHERE Date(`time`) = CURDATE() AND UserName = '[email protected]'

Not the last 24 hours, but the number of uses today

05-29-2012, 06:12 PM
livexxx Confirmed User Industry Role: Join Date: May 2005 Location: UK Posts: 1,201	what about something like SELECT UserName, Count(UserName) AS SumOfUses FROM table WHERE Date(`time`) = CURDATE() AND UserName = '[email protected]' Not the last 24 hours, but the number of uses today __________________ http://www.webcamalerts.com for auto tweets for web cam operators