Re: Supplied argument is not a valid MySQL result resource...

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"" <hk@hknets.de> schrieb im Newsbeitrag news:9bhh1c$2gg$2@toye.p.sourceforge.net... > 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? >