[tommyc325]

PHP Code:

# FileName="Connection_php_mysql.htm"

# Type="MYSQL"

# HTTP="true"

$hostname_blog_oconn = "xxx";

$database_blog_oconn = "xxx";

$username_blog_oconn = "xxx";

$password_blog_oconn = "xxx";

$blog_oconn = mysql_pconnect($hostname_blog_oconn, $username_blog_oconn, $password_blog_oconn) or trigger_error(mysql_error(),E_USER_ERROR); 









////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////







$ip = $_SERVER['REMOTE_ADDR'];

$time = time();



$ip_check = 'SELECT ip FROM `users_online` WHERE ip = \''.$_SERVER['REMOTE_ADDR'].'\'';

$ip_query = mysql_query($ip_check);

$num_rows = mysql_num_rows($ip_query);



if(!$num_rows) { //if no rows, meaning no ip's in db matched theirs, we will add them.

   $insert_new = mysql_query("INSERT INTO `users_online` (ip, time) VALUES ('$ip', '$time')");  

} //end if NOT THERE



//this means that they're already in there, so we update info.

   if($num_rows > 0) {

      $update = mysql_query('UPDATE `users_online` SET time=\''.time().'\' WHERE ip = \''.$_SERVER['REMOTE_ADDR'].'\'');

       if(!$update) die(mysql_error());

} // end UPDATE



//if time now - start time > 300 then its been 5 minutes, so we delete

   $delete_old = mysql_query("DELETE FROM `users_online` WHERE ((".time()."-time) > 300)");

     if(!$delete_old) die(mysql_error());



//show the number of people online now....

$id_query = @mysql_query("SELECT * FROM `users_online`");

$users_online = mysql_num_rows($id_query); 

Error: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/alteredimage.com/httpdocs/Connections/blog_oconn.php on line 25
Table 'alteredimage_com_-_ai2005.users_online' doesn't exist

the weird thing as you can tell is i`m not even connecting to the db called alteredimage_com_-_ai2005.

[UnrealEd]

replace:

PHP Code:

$ip_query = mysql_query($ip_check); 

with this:

PHP Code:

$ip_query = mysql_query($ip_check) or die(mysql_error()); 

and as the error says: there's no table named like that in your database

Greetz,
UnrealEd

[tommyc325]

ok understood but i`m not even connecting to the db there saying.

Table 'alteredimage_com_-_ai2005.users_online' doesn't exist

im trying to connect to ai_blog
and from there grab the table called users_online

[mab]

Since this is a persistent connection, it is probably reporting some previously used information.

Your code is missing a mysql_select_db(...) statement.