Login to download the latest version of Mint and your favorite Pepper, purchase additional licenses, or post in the Forum. Don't have an account? Create one!
I’m trying to display all the users who are currently online within the past 15 mins. At the moment I’m using this code, but it isn’t working.
$link = mysql_connect("localhost", "tmhai", "*******");
mysql_select_db("tmhai_mint", $link);
$result = mysql_query("SELECT * FROM mint_visit WHERE dt <= (". time() ." - 900)", $link);
$num_rows = count($result);
Would someone be able to help me out on this here.
I’m real sorry for sounding stupid, but I really don’t know what to do. I was provided the code above so I have absolutely no idea what it does, nor do I know what to do with the information in the above website.
Could someone perhaps code this for me? Please.
Well, depending on what referrer_is_local means in the database (and I don’t know) then you can probably pull something out, but until someone confirms, I can’t really advise further
Replace count() by mysql_num_rows() and dt <= by dt >=.
Surely this will only show page views in the last 15 mins and not unique users? Hence why I figured it would have to be tied to referrer_is_local (I’m assuming, perhaps incorrectly, that this is equal to 0 if it is their first visit and 1 thereafter)
Or use the secret crush cookie : )
You must be logged in to reply. Login above or create an account