Re: 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"" <johannes.janson@gmx.de> schrieb im Newsbeitrag news:9bh6jh$346$1@toye.p.sourceforge.net... > 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"" <hk@hknets.de> schrieb im Newsbeitrag > news:9bh369$d2h$1@toye.p.sourceforge.net... > > 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 > > (hk@hknets.de and/or Klaus.Haberkorn@sympat.de) > > > > > > > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > > For additional commands, e-mail: php-db-help@lists.php.net > > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >