TalkPHP - View Single Post - i am just using my fantasi but can i do like this ?

codefreek · 10-24-2008, 09:13 PM

"don't flame me now as i am really tired have been up all night",
yeah well my question is can i do this ?

PHP Code:


			
 function onlineCheck()
{
    $q = " SELECT * FROM users WHERE last_active='NOW()'";
    $pp = mysql_query($q); 
    $icheckd = mysql_num_rows($pp);
    if ($icheckd > 1) 
    {
    
        print "</br>he/she is still online!";
        exit;
    
    }

    else 
    {
        $q = "SELECT * FROM users WHERE last_active='NOW()'";
        $pp = mysql_query($q); 
        $icheckd = mysql_num_rows($pp);
        if ($icheckd > 0)
        { 
            $sql = "UPDATE `users` SET `last_active` = 'NOW()'";            
            $query = mysql_query($sql) or die(mysql_error());
        }
    }
}

Thank you in advance!

10-24-2008, 09:13 PM	#1 (permalink)
codefreek Super Moderator Join Date: Sep 2007 Location: Near you. Posts: 791 Thanks: 241	i am just using my fantasi but can i do like this ? "don't flame me now as i am really tired have been up all night", yeah well my question is can i do this ? PHP Code: function onlineCheck() { $q = " SELECT * FROM users WHERE last_active='NOW()'"; $pp = mysql_query($q); $icheckd = mysql_num_rows($pp); if ($icheckd > 1) { print "</br>he/she is still online!"; exit; } else { $q = "SELECT * FROM users WHERE last_active='NOW()'"; $pp = mysql_query($q); $icheckd = mysql_num_rows($pp); if ($icheckd > 0) { $sql = "UPDATE `users` SET `last_active` = 'NOW()'"; $query = mysql_query($sql) or die(mysql_error()); } } } Thank you in advance! __________________ Codefreek's - News Letter, Tech, & some random ramblings Last edited by codefreek : 10-25-2008 at 01:54 AM.