teething problems need help

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
gaogier
Forum Contributor
Posts: 391
Joined: Wed Mar 02, 2005 1:02 pm
Location: Portsmouth, UK
Contact:

teething problems need help

Post 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?
Last edited by gaogier on Wed Jul 27, 2005 8:13 pm, edited 1 time in total.
User avatar
anjanesh
DevNet Resident
Posts: 1679
Joined: Sat Dec 06, 2003 9:52 pm
Location: Mumbai, India

Post by anjanesh »

When you did $result = mysql_query() or die (mysql_error()) what was the error ?
theda
Forum Contributor
Posts: 332
Joined: Sat Feb 19, 2005 8:35 am
Location: USA

Post by theda »

Delete it ;)
gaogier
Forum Contributor
Posts: 391
Joined: Wed Mar 02, 2005 1:02 pm
Location: Portsmouth, UK
Contact:

Post by gaogier »

why delete it, the line error moves
gaogier
Forum Contributor
Posts: 391
Joined: Wed Mar 02, 2005 1:02 pm
Location: Portsmouth, UK
Contact:

Post 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'
gaogier
Forum Contributor
Posts: 391
Joined: Wed Mar 02, 2005 1:02 pm
Location: Portsmouth, UK
Contact:

Post by gaogier »

please help
timvw
DevNet Master
Posts: 4897
Joined: Mon Jan 19, 2004 11:11 pm
Location: Leuven, Belgium

Post 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...
gaogier
Forum Contributor
Posts: 391
Joined: Wed Mar 02, 2005 1:02 pm
Location: Portsmouth, UK
Contact:

Post by gaogier »

now its this

Useronline Insert Failed > Useronline Delete Failed > Access denied for user: 'gaogier@localhost' to database 'users'
gaogier
Forum Contributor
Posts: 391
Joined: Wed Mar 02, 2005 1:02 pm
Location: Portsmouth, UK
Contact:

Post by gaogier »

done it
Post Reply