Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\app/

Question

I'm getting a warning on my game when i make a character and i go through to confirmation i get this error :

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\app\class.engine.php on line 102 Unknown column 'ipaddress_reg' in 'field list

I was wondering what is up with it i visited my localhost/phpmyadmin but nothing worked

Line 100-103 :

final public function num_rows($sql)
{
    return $this->mysql['num_rows']($this->mysql['query']($sql, $this->connection));
}

Probably the repeated `$this->mysql` can you try `return $this->mysql['num_rows']['query']($sql, $this->connection);` — Funk Forty Niner, Jan 29 '14 at 22:30
Or as the error message says `Unknown column 'ipaddress_reg' in 'field list` — Funk Forty Niner, Jan 29 '14 at 22:31
Please take a look at the sidebar on the right. This question has been asked a million times before. — Jon, Jan 29 '14 at 22:37
Fred -ii- I followed your first step and my warning has turned into a fatal error : Fatal error: Call to undefined function m() in C:\xampp\htdocs\app\class.engine.php on line 102 — user3250830, Jan 29 '14 at 22:38
Ok, because if it were, since there is a space between `field` and `list` it would need to be wrapped in backticks. @user3250830 — Funk Forty Niner, Jan 29 '14 at 22:42
I made a structure in my DB called field_list and inside it there is ipaddress_reg and im just getting the same new error — user3250830, Jan 29 '14 at 22:46

johndavedecano · Answer 1 · 2014-01-29T22:48:13.857

0

The problem is their with your query or your connection. Also check if ipaddress_reg column exists on your subject table.

public function column_exists($table,$field)
{
    $query = mysql_query("SELECT * FROM $table LIMIT 1",$this->connection); 
    $column = mysql_fetch_array($query); 

    return false;

    if(isset($column[$field])) 
    {
        return true;
    }
}

public function is_connected()
{
    if(!$this->connection){ return false; }else{ return true; }
}

edited Jan 29 '14 at 22:48

answered Jan 29 '14 at 22:32

johndavedecano

492
5
11

Parse error: syntax error, unexpected T_PUBLIC in C:\xampp\htdocs\app\class.engine.php on line 102 Live 102: public function column_exists($table,$field) – user3250830 Jan 29 '14 at 22:51

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\app/

1 Answers1