[PHP-DB] Supplied argument is not a valid MySQL result resource

2002-08-09 Thread MET
I'm getting some massive errors on some pretty simple code. Included are the errors as well as the PHP function that is giving me issues. Any help would be greatly appreciated. And the weirdest thing, is that the code used to work ?? Line 267 is equal to this PHP line:

Re: [PHP-DB] Supplied argument is not a valid MySQL result resource

2002-08-09 Thread Jeffrey_N_Dyke
add an... or die(mysql_error()) to the $resultm = mysql_query($sqlm); statement and you'll have a lot more info for yourself, and the list if you still need assistance.

RE: [PHP-DB] Supplied argument is not a valid MySQL result resource...

2001-04-23 Thread Mark Roedel
-Original Message- From: Klaus Haberkorn [mailto:[EMAIL PROTECTED]] Sent: Saturday, April 21, 2001 6:18 AM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Supplied argument is not a valid MySQL result resource... Looks like many reasons cause this error-message, but I cannot find

Re: [PHP-DB] Supplied argument is not a valid MySQL result resource...

2001-04-21 Thread Klaus Haberkorn
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 =

[PHP-DB] Supplied argument is not a valid MySQL result resource...

2001-04-17 Thread Klaus Haberkorn
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

Re: [PHP-DB] Supplied argument is not a valid MySQL result resource...

2001-04-17 Thread Johannes Janson
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

Re: [PHP-DB] Supplied argument is not a valid MySQL result resource...

2001-04-17 Thread Klaus Haberkorn
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

Re: [PHP-DB] Supplied argument is not a valid MySQL result resource...

2001-04-17 Thread Johannes Janson
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