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 "e;Useronline Select Error > "e;;
}
//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, "e;SELECT DISTINCT ip FROM useronline WHERE file='$PHP_SELF'"e;);
if(!($result)) {
print "e;Useronline Select Error > "e;;
}
//number of rows = the number of people online
with
Code: Select all
//grab the results
$result = mysql_db_query($database, "e;SELECT DISTINCT ip FROM useronline WHERE file='$PHP_SELF'"e;) or die(mysql_error());
if(!($result)) {
print "e;Useronline Select Error > "e;;
}
//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