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]