Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in..HELP!

Why am I getting this error when im trying to registrer?

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

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

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\app\class.engine.php on line 102
Table 'r63b.users' doesn't exist

Code:

Code:

---

<?php

namespace Revolution;
if(!defined('IN_INDEX')) { die('Sorry, you cannot access this file.'); }
class engine
{
        private $initiated;
        private $connected;
       
        private $connection;
       
       
        final public function Initiate()
        {
                global $_CONFIG;
                if(!$this->initiated)
                {
                        $this->setMySQL('connect', mysql_connect);
                        $this->setMySQL('pconnect', mysql_pconnect);
                        $this->setMysql('select_db', mysql_select_db);
                        $this->setMySQL('query', mysql_query);
                        $this->setMySQL('num_rows', mysql_num_rows);
                        $this->setMySQL('fetch_assoc', mysql_fetch_assoc);
                        $this->setMySQL('fetch_array',mysql_fetch_array);
                        $this->setMySQL('result', mysql_result);
                        $this->setMySQL('free_result', mysql_free_result);
                        $this->setMySQL('escape_string', mysql_real_escape_string);
                       
                        $this->initiated = true;
               
                        $this->connect($_CONFIG['mysql']['connection_type']);
                }
        }
       
        final public function setMySQL($key, $value)
        {
                $this->mysql[$key] = $value;
        }
       
       
        /*-------------------------------Manage Connection-------------------------------------*/
       
        final public function connect($type)
        {
                global $core, $_CONFIG;
                if(!$this->connected)
                {
                        $this->connection = $this->mysql[$type]($_CONFIG['mysql']['hostname'], $_CONFIG['mysql']['username'], $_CONFIG['mysql']['password']);
                       
                        if($this->connection)
                        {
                                $mydatabase = $this->mysql['select_db']($_CONFIG['mysql']['database'], $this->connection);
                               
                                if($mydatabase)
                                {
                                        $this->connected = true;       
                                }
                                else
                                {
                                        $core->systemError('MySQL Engine', 'MySQL could not connect to database');
                                }
                        }
                        else
                        {
                                $core->systemError('MySQL Engine', 'MySQL could not connect to host');                       
                        }
                }
        }
       
        final public function disconnect()
        {
                global $core;
                if($this->connected)
                {
                        if($this->mysql['close'])
                        {
                                $this->connected = false;
                        }
                        else
                        {
                                $core->systemError('MySQL Engine', 'MySQL could not disconnect.');
                        }
                }
        }
       
        /*-------------------------------Secure MySQL variables-------------------------------------*/
       
        final public function secure($var)
        {
                return $this->mysql['escape_string'](stripslashes(htmlspecialchars($var)));
        }
       
        /*-------------------------------Manage MySQL queries-------------------------------------*/
       
        final public function query($sql)
        {
                return $this->mysql['query']($sql, $this->connection) or die(mysql_error());
        }
       
        final public function num_rows($sql)
        {
                return $this->mysql['num_rows']($this->mysql['query']($sql, $this->connection));
        }
       
        final public function result($sql)
        {
                return $this->mysql['result']($this->mysql['query']($sql, $this->connection), 0);
        }
       
        final public function free_result($sql)
        {
                return $this->mysql['free_result']($sql);
        }
       
        final public function fetch_array($sql)
        {
                $query = $this->mysql['query']($sql, $this->connection);
               
                $data = array();
               
                while($row = $this->mysql['fetch_array']($query))
                {
                        $data[] = $row;
                }
               
                return $data;
        }
       
        final public function fetch_assoc($sql)
        {
                return $this->mysql['fetch_assoc']($this->mysql['query']($sql, $this->connection));
        }








}
?>

---

Some screenies would help abit more:)

This is after i press Register:
http://i41.tinypic.com/29qcs2v.png

This is the code:
http://i40.tinypic.com/27zda36.png

It basically says that you don't have a table called users... lol.

You tried reading the errors and understand what is going on?

As BaasHotel said, i think you need the SQL so you can insert users into your database,

Read the errrors before making posts, clearly says the users table doesn't exist.

Sorry, im kinda new at this. I downloaded the SQL from here. If I make a table called users, what should i type in that table?

Quote:

---

Originally Posted by sn00w

Sorry, im kinda new at this. I downloaded the SQL from here. If I make a table called users, what should i type in that table?

---

Just import the database that you got with your download.

I did but the table users didnt follow.

Quote:

---

Originally Posted by sn00w

I did but the table users didnt follow.

---

Then you dont have a correct database or correct database settings.

Quote:

---

Originally Posted by HillBilly

Then you dont have a correct database or correct database settings.

---

So what can I do?

Quote:

---

Originally Posted by sn00w

So what can I do?

---

First run this SQL in your database:

PHP Code:

---

SET @@global.sql_mode = ''; 


---

and restart your mysql.
Then import the database you got from that tutorial.

Quote:

---

Originally Posted by BaasHotel

First run this SQL in your database:

PHP Code:

---

SET @@global.sql_mode = ''; 


---

and restart your mysql.
Then import the database you got from that tutorial.

---

Thanks, but I've fix it already, I downloaded another SQL.
But please, do you think you can help me with an error? When im trying to enter my client it loads and then it turn black. After a while it turns white and an error says: Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 261904 bytes) in C:\xampp\htdocs\app\tpl\class.html.php on line 27

Can you please help me? :)

Set your memory limit in the php.ini higher

Ok, where can I find php.ini?