JasonORDSW Posted September 30, 2003 Share Posted September 30, 2003 I am running a members profile ssytem.. and I am trying to get a page to display the total of NEW members since a individual last logged on. My current code is: $query_newmembers = mysql_query("SELECT COUNT(*) FROM members WHERE TO_DAYS(stamp_approved)-TO_DAYS(\'$stamp_lastlogin2\')>0 AND status=\'A\' AND level IN (2,3,4)"); however it does not seem to be displaying the PROPER number of new members since a person last logged on (lastlogin2) Can anyone help? Thanks! Jason[/code] Link to comment https://forums.phpfreaks.com/topic/1085-count-from-one-date-to-another/ Share on other sites More sharing options...
shivabharat Posted October 1, 2003 Share Posted October 1, 2003 Whats the filed type of \"stamp_approved\" is that timestamp/datetime or date? This is the synaxt for TO_DAYS SELECT TO_DAYS(\'2003-10-01\'); Link to comment https://forums.phpfreaks.com/topic/1085-count-from-one-date-to-another/#findComment-3712 Share on other sites More sharing options...
JasonORDSW Posted October 1, 2003 Author Share Posted October 1, 2003 The Field Type for stamp approved and for lastlogin2 is datetime I thank you in advance for your help! Jason Link to comment https://forums.phpfreaks.com/topic/1085-count-from-one-date-to-another/#findComment-3722 Share on other sites More sharing options...
shivabharat Posted October 2, 2003 Share Posted October 2, 2003 If you have the filed type as time stamp you may need to extract the date alone used SELECT COUNT(*) FROM members WHERE TO_DAYS(substring(<field_name>,1,11)) -TO_DAYS(\'$stamp_lastlogin2\') )>0 AND status=\'A\' AND level IN (2,3,4)"); ensure that \"$stamp_lastlogin2\" is in date format YYYY-MM-DD Link to comment https://forums.phpfreaks.com/topic/1085-count-from-one-date-to-another/#findComment-3735 Share on other sites More sharing options...
JasonORDSW Posted October 2, 2003 Author Share Posted October 2, 2003 Both the stamp approved and the lastlogin2 are datetime fields.. I wanted to kep it this way.. so it has a more ACCURATE reporting for when you do certain functions on the site. Looks like I will have to extract the date ONLY for both fields.. THANKS for your help! Any other suggestions.. please pass them along! Jason Link to comment https://forums.phpfreaks.com/topic/1085-count-from-one-date-to-another/#findComment-3737 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.