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

sarettah · 05-29-2012, 08:44 PM

select whatever from table where time>=date_sub( now() ,INTERVAL 1 DAY)

should give you your activity in the last 24 hours

.

05-29-2012, 08:44 PM
sarettah see you later, I'm gone Industry Role: Join Date: Oct 2002 Posts: 14,066	select whatever from table where time>=date_sub( now() ,INTERVAL 1 DAY) should give you your activity in the last 24 hours . __________________ All cookies cleared!