[SOLVED] Help with Live Data

[mike1313]

I'm using the live data tutorial and I can't seem to get it to work.

 

Any help?

 

Ajax code:

function createRequestObject() {
    
        var req;
    
        if(window.XMLHttpRequest){
            // Firefox, Safari, Opera...
            req = new XMLHttpRequest();
        } else if(window.ActiveXObject) {
            // Internet Explorer 5+
            req = new ActiveXObject("Microsoft.XMLHTTP");
        } else {
            // There is an error creating the object,
            // just as an old browser is being used.
            alert('There was a problem creating the XMLHttpRequest object');
        }
    
        return req;
    
    } 

var http = createRequestObject();
    
    function sendRequest2(act) {
        
        // Open PHP script for requests
        http.open('get', 'chatusers.php?act='+act);
        http.onreadystatechange = handleResponse2;
        http.send(null);
    
    } 

    function handleResponse2() {
    
        if(http.readyState == 4 && http.status == 200){
    
            // Text returned FROM PHP script
            var response2 = http.response2Text;
    
            if(response2) {
                // UPDATE ajaxTest content
                document.getElementById("users").innerHTML = response2;
                setTimeout('userc();' ,'2000');
            }
    
        }
    } 

       function userc() {
        sendRequest2('userc');
    }

 

and chat users.php

 

<?php

mysql_connect("dbhost","dbuser","pass");
mysql_selectdb("dbname");

$time = time()-100;

if ($_GET['act'] == "userc") { 

$who = mysql_query("SELECT * FROM players WHERE lastcactive >= $time");

while ($who2 = mysql_fetch_array($who)) {
echo "$who2[username]<br>";
}
}
?>

 

Note I've hidden my database also in the Ajax there's a 2 behind everything because I already have ajax running on the page updating a div that has the same names so 2's were added.

[mike1313]

I solved it.