Welcome Guest, Not a member yet? Register   Sign In
Fatal error: Call to a member function num_rows() on a non-object
#1

[eluser]QuibaX[/eluser]
Hi,

I've been having an error and i just can't figure out how to fix it.
This function produces that error :

Code:
function TransferActivated()
        {
            $webdb = $this->load->database('webdb', TRUE);
            $manager = $this->load->database('manager', TRUE);
            
            $activatedUsers = $webdb->query("SELECT * FROM users WHERE activated='1'");
            if($activatedUsers->num_rows() > 0) -> Error ...
            {
                foreach($activatedUsers->result() as $row)
                {
                    $password = md5($row->username . $row->password . 341765);
                    $manager->query("INSERT INTO accounts(username, password, email) VALUES('$row->username', '$password', '$row->email'");
                }
            }
            $webdb->close();
            $manager->close();
        }

However, the following function does work and is almost done the same way.

Code:
function GetNotActivatedUsers()
        {
            $webdb = $this->load->database('webdb', TRUE);
            $query = $webdb->query("SELECT * FROM users WHERE activated IS NULL");
            return $query->num_rows();
        }

Can anyone help ?
Thanks,

QuibaX


Messages In This Thread
Fatal error: Call to a member function num_rows() on a non-object - by El Forum - 10-09-2010, 03:26 AM



Theme © iAndrew 2016 - Forum software by © MyBB