Re: [PHP-DB] Supplied argument is not a valid MySQL result resource...
Looks like many reasons cause this error-message,
but I cannot find a problem in the Query:
ie.:
$db_handle = mysql_connect("localhost", "mysql", "mysql");
if($db_handle)
{
$result = mysql_db_query("mysql", "select * from user", $db_handle);
if($result = TRUE)
{
$row = mysql_num_rows($result);
()
The same simplified statement works fine in the Win32-client-tool,
connected as the same user.
The table "user" exists and "mysql" has any privileges from localhost and %
in "user" and "db"
I surely made some experiments with Caps or not.
I built a new apache 1.3.12 with a static php4.0.4pl1 module and
mysql-support.
Runs fine, but the problem is the same.
I have no more idea...
"Johannes Janson" [EMAIL PROTECTED] schrieb in im Newsbeitrag:
9bhkqv$aai$[EMAIL PROTECTED]
Hi,
i don't get that.
Examlpe: tablename: test , entry: id 001; name: John Doe
$result = mysql_query("SELECT * FROM test");
$row = mysql_fetch_whatever($result); // everything ok
$result = mysql_query("SELECT * FROM tet");
$row = mysql_fetch_wahtever($result); // Warning: Supplied arggument is
not
a valid
$result = mysql_query("SELECT nonexistent FROM test");
$row = mysql_fetch_whatever($result); // Warning: Supplied argument is not
$result = mysql_query("SELECT * FROM test WHERE id='002'");
$row = mysql_fetch_whatever($result); // no errormsg, $result=true but
empty
That's what I get. So there must be something wrong with the query.
Johannes
""Klaus Haberkorn"" [EMAIL PROTECTED] schrieb im Newsbeitrag
9bhh1c$2gg$[EMAIL PROTECTED]">news:9bhh1c$2gg$[EMAIL PROTECTED]...
thank You, Johannes,
but I think we can skip this,
we reduced the query statement to the most simple one:
"SELECT * FROM {tablename}"
if the tablename is wrong, then another error message is issued.
the result is not treated by a while-loop but just by fetch_num_rows,
which at least reports the error.
(and, by the way, the same script runs on another system)
so we are more looking for problems with apache versions
and/or modules.
we also checked access-rights, but this also causes different errors.
any other idea?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Supplied argument is not a valid MySQL result resource...
Installation Details: SuSE Linux 7.1 kernel 2.4 + apache 1.3.14 + php4.0.4pl1-1 + mysql 3.23.30-2 The following error message appears: "Warning: Supplied argument is not a valid MySQL result resource in /www/wp/php/login.php on line 29" Remarks: php4 runs fine and returns "not FALSE" for function mysql_db_query (means query is ok) or mysql_query. But the result of the query causes the error above. Any other function using the query-result does so also. The same php-script runs fine on other systems with the same environment. The Access-Rights are completely "open" for the whole development site and all of the mysql-users have full access, there are only a few test-records in the table (no question of size!). Can anybody help us with this problem? Thanks in Advance Klaus ([EMAIL PROTECTED] and/or [EMAIL PROTECTED]) -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Supplied argument is not a valid MySQL result resource...
thank You, Johannes,
but I think we can skip this,
we reduced the query statement to the most simple one:
"SELECT * FROM {tablename}"
if the tablename is wrong, then another error message is issued.
the result is not treated by a while-loop but just by fetch_num_rows,
which at least reports the error.
(and, by the way, the same script runs on another system)
so we are more looking for problems with apache versions
and/or modules.
we also checked access-rights, but this also causes different errors.
any other idea?
""Johannes Janson"" [EMAIL PROTECTED] schrieb im Newsbeitrag
9bh6jh$346$[EMAIL PROTECTED]">news:9bh6jh$346$[EMAIL PROTECTED]...
Hi,
you usually get the error if your query is wrong and
you try to call mysql_fetch_array in a while loop.
It's easier if you post the relevant lines of code but
I'd say there is something wrong with your query.
Johannes
""Klaus Haberkorn"" [EMAIL PROTECTED] schrieb im Newsbeitrag
9bh369$d2h$[EMAIL PROTECTED]">news:9bh369$d2h$[EMAIL PROTECTED]...
Installation Details:
SuSE Linux 7.1 kernel 2.4 + apache 1.3.14 + php4.0.4pl1-1 + mysql
3.23.30-2
The following error message appears:
"Warning: Supplied argument is not a valid MySQL result resource in
/www/wp/php/login.php on line 29"
Remarks:
php4 runs fine and returns "not FALSE" for function mysql_db_query
(means
query is ok) or mysql_query.
But the result of the query causes the error above. Any other function
using
the query-result does so also.
The same php-script runs fine on other systems with the same
environment.
The Access-Rights are completely "open" for the whole development site
and
all of the mysql-users have
full access, there are only a few test-records in the table (no question
of
size!).
Can anybody help us with this problem?
Thanks in Advance
Klaus
([EMAIL PROTECTED] and/or [EMAIL PROTECTED])
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
