Time difference

[musalpay]

<%
onlndt = now() - 0.004

onlinemembers = conn.execute("SELECT count(*) FROM members where lastlogindate > '"& onlndt &"' ORDER BY lastlogindate ")(0)

%>
I am trying to count the number of members logined last one minute or another time range. But onlinemembers always shows "0"

What should I do?

http://www.dersisteyen.com

http://www.ozelders.gen.tr

 

[r937]

whatever language that is (php?) it's obviously not giving you what you want

furthermore, the ORDER BY clause is inappropriate on a COUNT(*) query

try this --

SELECT count(*) 
  FROM members 
 where lastlogindate > date_sub(now(), interval 2 minute)

r937.com | rudy.ca

 

[musalpay]

<%
onlndt = now() - 0.004

onlinemembers = conn.execute("SELECT count(*) FROM members where lastlogindate > '"& onlndt &"'")(0)

%>
Language is asp

Thank you r937, you were right about order by clause but still doesnot work

http://www.dersisteyen.com

http://www.ozelders.gen.tr

 

[r937]

did you try my query?

r937.com | rudy.ca

 

[musalpay]

yes thank you very much It works properly.

http://www.dersisteyen.com

http://www.ozelders.gen.tr