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? 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. 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 Link to comment https://forums.phpfreaks.com/topic/119720-solved-members-online-list/#findComment-616828 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.