Hey
I want something that can count how many users that is online on my site.
Im using ASP and i just wonder if i can use ActionScript?
Im totallity a newbie with ActionScript and Flash, but im ready to learn.
I want the flash to connect to my database (microsoft access db) and count how many users that is online and then type it. But i want it to be refreshed every secound. If it is like 14 users online, and a users just logged in on my site i what it to type 15 directly for all users. Is it possible?
EDIT:
Like this…
set connection = server.createObject(“adodb.connection”)
connection.open “Provider=Microsoft.Jet.OLEDB.4.0;Data Source=” & Server.MapPath(“db.mdb”)
onlinenow = DateAdd(“n”, -10, Now)
SQL = “SELECT COUNT(*) AS onlines FROM Members WHERE oc > #” & onlinenow & “#”
SET rs = Connection.Execute(SQL)
rs(“onlines”)