Warning: mysql_fetch_array():

[slimjim]

I have a problem. I get this warning :
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/site/public_html/lib/mysql.lib on line 29
Note that this problem runs fine on my server. But not fine on others. Thats my problem.
Below is the mysql.lib file

<?
if (!$mysq_lib_loaded)
{

  function c(){
      global $db_host, $db_login, $db_pswd;
      $db=mysql_connect($db_host,$db_login,$db_pswd);
      return $db;
  }

 function q($q_str){
    global $db_name;
    $r = mysql($db_name,$q_str);
    return $r;
 }

 function d($db){
//    mysql_close($db);
 }

 function e($r)
 {
  if(@mysql_numrows($r))
   return 0;
  else return 1;
 }

 function f($r){
  return mysql_fetch_array($r); //this is the line error
 }

 function nr($r){
  return mysql_num_rows($r);
 }

$dv=c();
$rv=q("select * from sysvars");
while($va = f($rv)) {${$va[name]}=$va[value];};
d($dv);

$mysq_lib_loaded=1;

}
?>

Now i get my error using the page below. Now like i said on my server runs fine. Its on other servers that i am having problems with :

<?
include "../tpl/clients_top.ihtml";
require("../conf/sys.php");
require("../lib/mysql.lib");
require "../lib/mail.lib";


$db = c();


$cmp_id = f(q("select uid FROM safelistdata where id=".$uid));
$safelistowner = f(q("select email from members where id=".$cmp_id[0]));
$details = f(q("select * FROM  safelistdata where id=".$id));
$email = $details[email];
$fname = $details[fname];
$lname = $details[lname];
$pswd = $details[password];
$safemail = $details[safemail];
$rdate = $details[rdate];

$sslnk=$ROOT_HOST."safelist_register.php?uid=$uid";
$sllnk=$ROOT_HOST."safelist_login.php?uid=$uid";

MsgFromTpl($email,"Your safelist Info!","../tpl/resendinfo.mtl");
 print "Safelist Clients info has been sent to $fname $lname [$email]";




include "../tpl/clients_bottom.ihtml";
?>

[ereptur]

function q($q_str){
    global $db_name;
    $r = mysql($db_name,$q_str);
    return $r;
 }

try this.

function q($q_str){
   global $db_name;
   $r = mysql_query($q_str,$db_name);
   return $r;
}

[slimjim]

Well that didnt work.

why would it work fine on mine and not others. If you look at the code really nothing to it.

Not making alot of sence to me at all.

[slimjim]

is there anything between php 4.2.2 and 4.3.1 that could such errors like that and of so is there something based on what you see, something that can work with both versions ?

[ereptur]

It looks like you're using a mysql library instead of the built-in functions directly. Could there possibly be something wrong with those functions or are you using them wrong?

Just a thought.

[tsinka]

Hi,

I'd suggest to extend your functions and add some mysql_error() calls to the mysql functions to see what exactly the error is, e.g.

mysql_connect(...) or die("Error: ".mysql_error());
mysql_select_db(...) or die("Error: ".mysql_error());

That will give you a hint about what might be going wrong.

[slimjim]

Well this one i really need to know why. Why would this work.

This works :

function f($r){
    if ($r) {
      return mysql_fetch_array($r);
  }
 }

This one causes me errors :

function f($r){
  return mysql_fetch_array($r);
 }

Is it that I needed the 2 }} please do tell me. I wasn't sure but then noticed that the I had {{ 2 of them and figured i needed to at the end too.

[tsinka]

Hi,

I think you need the if statement because it makes no sense to do a mysql_fetch_array if $r is 0. $r is 0 when there was an error in your query when you executed mysql_query. Did you add the mysql_error() calls because that would give you human readable error messages 🙂