richiec Posted August 14, 2008 Share Posted August 14, 2008 All i am trying to do right now is add a members online list at the bottom of the page.. I have that all working however if someone views the page and is not loged in it will still put them into the db.. heres the code.. $activeuser = $_SESSION["myusername"]; if ($activeuser = true) { $lastactive = time(); $activeuser = $_SESSION["myusername"]; $query = "SELECT onlineid FROM online WHERE username = '$activeuser'"; $result=mysql_query($query) or die(mysql_error()); $num = mysql_num_rows($result); if ($num == 0) { // Insert new visitor $query = "INSERT INTO online (username, lastactive) VALUES ('$activeuser', $lastactive)"; $result=mysql_query($query) or die(mysql_error()); } else { // Update exisiting visitor $query = "UPDATE online SET lastactive = $lastactive WHERE username = '$activeuser'"; $result=mysql_query($query) or die(mysql_error()); } } else { echo ""; } the if ($activeuser = true) part was just something i tried but still didnt work.. is there anyway to do it so that you have to be loged in for it to work and not put a blank username into the db? Quote Link to comment https://forums.phpfreaks.com/topic/119720-solved-members-online-list/ Share on other sites More sharing options...
revraz Posted August 14, 2008 Share Posted August 14, 2008 if ($activeuser = true) should be if ($activeuser == true) Since you only use 1 = in your IF statement, your statement will always be true. Quote Link to comment https://forums.phpfreaks.com/topic/119720-solved-members-online-list/#findComment-616802 Share on other sites More sharing options...
richiec Posted August 14, 2008 Author Share Posted August 14, 2008 That worked, thank you very much Quote Link to comment https://forums.phpfreaks.com/topic/119720-solved-members-online-list/#findComment-616828 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.