mysql_fetch_row()

seby

i have two different scripts that make two different database calls, both scripts are included into the same page..

one script query:

$result = $db->sql("SELECT * FROM $user WHERE nick = '$user' AND password = '$pass'");
 while($row = mysql_fetch_row($result)) {

second query:

$result2 = @mysql_query("SELECT * FROM userfield WHERE userid = '$bbuserinfo[userid]'", $db2);
while ($info = mysql_fetch_row($result2)) {

and it gives me this error:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/public_html/comments.php on line 59

are they some how conflicting with eachother?, how do I fix it?

Xzone5

Which section is the one with the error?

seby

the first query works fine, but when I include the file with the second query is when i get the error, both scripts work fine when they are not included with eachother, once I include the error shows up.

diego25

Use mysql_Error() to see what MySQL is complaining about. Also check that $db2 is ok and connected to the server.

Diego

seby

I tried that, using

  if (!$result2) {
    echo("<p>Error performing query: " . mysql_error() . "</p>");
    exit();
  }

both queries are connecting find because they both return information if they aren't included, once both scripts are include() into the same file thats when the error shows up.. this is breaking my stones and i cannot figure out the cause 🙁