mysql_fetch_array is not a valid mysqlresult
| From: | Sascha Braun | Date: | Wed, 07 Aug 2002 12:59:52 +0000 |
| Subject: | mysql_fetch_array is not a valid mysqlresult | ||
| Groups: | php.dev | ||
| Request: | Send a blank email to php-dev+get-86594@lists.php.net to get a copy of this message | ||
Hello,
I tried to implement the PHP Session Management. While I did this another error occured.
All my working mysql_fetch_array($ResultQuery, MYSQL_ASSOC) funktions went broken.
Why is it like that and how can i fix them?
The Failure message is:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in
C:\Webverzeichnis\docs\living_sports\include\login.inc.php on line 8
and the Query looks like this:
$Query = "SELECT Benutzername, Passwort";
$Query .= " FROM benutzer_db";
$Query .= " WHERE Benutzername =
'".$_REQUEST['nickname']."'";
$Query .= " AND Passwort =
'".md5($_REQUEST['password'])."'";
$Insert = mysql_query($Query, $connect);
$arrResult = mysql_fetch_array($Insert, MYSQL_ASSOC);
whats wenting wrong?
I changed the session tmp, which was unset to ".;c:\path-to-my-server\tmp"
I'm developing on Windows 2000 with Apache 2.0.35
Please gimme a Hint.
Thanx
Sascha Braun