Page 1 of 1

teething problems need help

Posted: Wed Jul 27, 2005 1:39 pm
by gaogier
Useronline Insert Failed > Useronline Delete Failed > Useronline Select Error >
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/gaogier/public_html/Romeo.php on line 39

Code: Select all

print &quote;Useronline Select Error > &quote;; 
} 

//number of rows = the number of people online
$user = mysql_num_rows($result);
the problem is the line 39 is the blank one, what do i do?

Posted: Wed Jul 27, 2005 1:47 pm
by anjanesh
When you did $result = mysql_query() or die (mysql_error()) what was the error ?

Posted: Wed Jul 27, 2005 1:47 pm
by theda
Delete it ;)

Posted: Wed Jul 27, 2005 1:50 pm
by gaogier
why delete it, the line error moves

Posted: Wed Jul 27, 2005 2:16 pm
by gaogier
i was told to replace this

Code: Select all

//grab the results
$result = mysql_db_query($database, &quote;SELECT DISTINCT ip FROM useronline WHERE file='$PHP_SELF'&quote;); 
if(!($result)) { 
print &quote;Useronline Select Error > &quote;; 
} 

//number of rows = the number of people online
with

Code: Select all

//grab the results
$result = mysql_db_query($database, &quote;SELECT DISTINCT ip FROM useronline WHERE file='$PHP_SELF'&quote;) or die(mysql_error()); 
if(!($result)) { 
print &quote;Useronline Select Error > &quote;; 
} 

//number of rows = the number of people online
and now i get this error

Useronline Insert Failed > Useronline Delete Failed > Access denied for user: '@localhost' to database 'users'

Posted: Wed Jul 27, 2005 3:41 pm
by gaogier
please help

Posted: Wed Jul 27, 2005 3:53 pm
by timvw
It's obvious not?

Access denied for user: '@localhost' to database 'users'

So you need to mysql_connect with a user that has rights to delete on the given database/table...

Posted: Wed Jul 27, 2005 8:13 pm
by gaogier
now its this

Useronline Insert Failed > Useronline Delete Failed > Access denied for user: 'gaogier@localhost' to database 'users'

Posted: Wed Jul 27, 2005 8:46 pm
by gaogier
done it