GoFuckYourself.com - Adult Webmaster Forum - View Single Post

sarettah · 10-01-2005, 10:21 PM

If the data is stored as a regular datetime field then:

SELECT COUNT(ID) FROM `Members` WHERE Status = 'Active' AND date_format(registration, '%m-%d-%y') ='10-01-05'

Should get you all the registrations for October 1.

10-01-2005, 10:21 PM
sarettah see you later, I'm gone Industry Role: Join Date: Oct 2002 Posts: 14,150	If the data is stored as a regular datetime field then: SELECT COUNT(ID) FROM `Members` WHERE Status = 'Active' AND date_format(registration, '%m-%d-%y') ='10-01-05' Should get you all the registrations for October 1. __________________ All cookies cleared!