GoFuckYourself.com - Adult Webmaster Forum - View Single Post

Brujah · 05-18-2011, 05:29 PM

Code:

select count(*) from antiabuse where 'time' < now() - 3600

This query says you want a count of all rows where the datetime is less than 1 hour ago (now-3600 seconds). Don't you want to count all rows in the past 1 hour?

05-18-2011, 05:29 PM
Brujah Beer Money Baron Industry Role: Join Date: Jan 2001 Location: brujah / gmail Posts: 22,157	Code: select count() from antiabuse where 'time' < now() - 3600 This query says you want a count of all rows where the datetime is less than 1 hour ago (now-3600 seconds). Don't you want to count all rows in the past 1 hour? __________________ Free Premium Domain Lists and Tools at Clickmojo.com* For Sale: Obscenity.com