query 'SET NAMES utf8' error: mysql_num_rows() expects parameter 1 to be resource

[argosback]

Hello, when I run the following query $db->ExecuteSQL('SET NAMES utf8'); I get the following error:

 # Line 121
 mysql_num_rows() expects parameter 1 to be resource, boolean given

I fixed with:

 @@ -118,8 +118,13 @@ class MySQL {
      function ExecuteSQL($query){
          $this->lastQuery     = $query;
          if($this->result     = mysql_query($query, $this->databaseLink)){
 -            $this->records   = @mysql_num_rows($this->result);
 -            $this->affected  = @mysql_affected_rows($this->databaseLink);
 +            if (gettype($this->result) === 'resource') {
 +                $this->records   = @mysql_num_rows($this->result);
 +                $this->affected  = @mysql_affected_rows($this->databaseLink);
 +            } else {
 +                $this->records  = 0;
 +                $this->affected = 0;
 +            }

If there is another way to run this query, please tell me

[Gummibeer]

@argosback it would be nice if you can provide a pull-request with your solution. it's much easier to merge as copy'n'paste. ;)

[argosback]

I send my pull-request :)

[Gummibeer]

thx for #43 pull-request! :) want to use this class in a big Project so i'm interestet in good solutions and a wide range of usability.

[behzad900]

i fixed this just add utf8 charset in class.DPBO.php in $dns

$dsn      = 'mysql:dbname=' . DATABASE_NAME . ';host=' .DATABASE_HOST.';charset=utf8';