php function showing error like mysql_fetch_array() expects parameter 1 to be resource array given

Question

In php I have a function and inside that function I have one query like this

  public function hookHome($params)
  {
    $defaultLanguage = (int)(Configuration::get('PS_LANG_DEFAULT'));
    global $cookie, $smarty;
    $value=array();
    $sql_select="SELECT DISTINCT country_name,country_ISO from "._DB_PREFIX_."storeinfo where status='1'";
    $result=Db::getInstance()->ExecuteS($sql_select);
      while($row=mysql_fetch_assoc($result))
      {
        $value[] = $row;
      }
     $smarty->assign('array',$value);
     $smarty->assign('default',$defaultLanguage);
  }

But after execution of query it is showing an error like Warning: mysql_fetch_array() expects parameter 1 to be resource, array given in storeinfo.php on line 8;

So can here some one kindly tell me what is the issue here? Any help and suggestions will be really appreciable. Thanks

As with 1 Billion 28 Million and 50 only similar cases, your query is failing and you are not checking for return value — Hanky Panky, May 09 '13 at 08:27

score 1 · Answer 1 · answered May 09 '13 at 08:30

your code $result=Db::getInstance()->ExecuteS($sql_select); is returning an array. you need a mysql_resultset to be passed into mysql_fetch_assoc.

it seems that your using some library that is wrapped around the mysql extension. You should check to see what it returns and maybe it self has a method to iterate through results.

php function showing error like mysql_fetch_array() expects parameter 1 to be resource array given

1 Answers1