invalid MySQL resource

[Inssider]

For some reason, I'm getting a:

Warning: Supplied argument is not a valid MySQL result resource in library.php on line 6

whenever I run my script. It occurs whenever I try to use the mysql_numrows function or the mysql_result function (those are the two I was using). Does anyone know why? [sig][/sig]

 

[rycamor]

It probably means the mysql user you have chosen to run the script doesn't have rights to these resources. Or you have supplied the wrong user/password/hostname combination. Can you log in from the command line and run the same queries as that user? [sig][/sig]

 

[Inssider]

The thing is, my other scripts work fine. They all connect to the database using the same config file, and the other scripts work flawlessly. But when I try to create another script, I get the result resource errors. [sig][/sig]

 

[rycamor]

Are you saying it's only when you use 'mysql_numrows' function or the 'mysql_result' function? [sig][/sig]

 

[Inssider]

No, but those were the two I was using at the time.

However, I fixed the problem by adding the function code inline, instead of in a separate object created in an include file. It works now, but I'd still like to know why it was happening when I stuck the function code in the class. [sig][/sig]