[monkey123]

PHP Code:

<?



$server = 'xxx'; //your database host

$db_user = 'xxx'; //your database username

$db_pass = 'xxx'; //your database password

$dbname = 'xxx'; //your database name



/* Database Stuff, do not modify below this line */

$connection = mysql_pconnect("$server","$db_user","$db_pass") 

    or die ("Couldn't connect to server.");



$db = mysql_select_db("$dbname", $connection)

    or die("Couldn't select database.");

    



$table = "usersonline"; //Table where information is kept

$timeoutseconds = 300; //Recommended





//Fetch Time

$time = time();

$timeout = $timestamp - $timeoutseconds;

$ip = $REMOTE_ADDR;

$domain=$_GET['domain'];



//Insert User

$insert = mysql_db_query($dbname, "INSERT INTO $table VALUES ('$time','$ip','$domain')") or die("Failed1!");



//Delete User

$delete = mysql_db_query($dbname, "DELETE FROM $table WHERE timestamp<$timeout") or die("Failed2!");



//Fetch Users Online

$result = mysql_db_query($dbname, "SELECT DISTINCT ip FROM $table") or die("Failed!3");

$users = mysql_num_rows($result);



//spit out the results

if($users == 1) {

print("$users User Online!\n");

} else {

print("$users Users Online!\n");

}

?>

help me, iv been through it a million time and it still fails on this line.

PHP Code:

$insert = mysql_db_query($dbname, "INSERT INTO $table VALUES ('$time','$ip','$domain')") or die("Failed1!"); 

[Bonzo]

I think your insert line is incomplete as you are not specifying where to input the values ?

PHP Code:

$insert = mysql_db_query($dbname, "INSERT INTO $table VALUES ('$time','$ip','$domain')") or die("Failed1!"); 

Should be - altering ( time, ip, domain ) to suite your database column names.

PHP Code:

$insert = mysql_db_query($dbname, "INSERT INTO $table ( time, ip, domain ) VALUES ('$time','$ip','$domain')") or die("Failed1!"); 

Anthony

[Beyonder]

echo 'this INSERT statement' when program is running.

Paste the statement to here.

[Sabu]

When you say "it still fails on this line", do you mean that PHP crashes, or it displays "failed!" meaning that mysql literally failed the query?
Updating Bonzo's suggestion:

PHP Code:

 $insert = mysql_db_query($dbname, "INSERT INTO $table ( time, ip, domain ) VALUES ('$time','$ip','$domain')") or die("Failed! <b>Mysql Said:</b><br><br>".mysql_error()); 

Just for debugging purposes, obviously you wouldn't show this extra information on your final site.