Function Call Help

[clanstyles]

Why doesn't this work? I get

Fatal error: Call to a member function query() on a non-object in /home/xxxxx/xxxxxxxxxxx/xxxxxxxxxxxx.com/includes/class.user.php on line 27

 

function checkLogin($username, $password) {

$sql = new mysqlQuery();

$sql->mysqlQuery();

$sql = "select * from users where username='$username' and password='$password' LIMIT 1";

$results = $sql->query($sql) ? "true" : "false";

 

if($results)

{

$array = $sql->fetch_array($sql->link_id, $sql);

$this->username = $username;

$this->password = $password;

$_SESSION['username'] = $username;

$_SESSION['password'] = $password;

}

}

 

I didn't include sql connection and a few other methods since they aren't needed.

<?php

class mysqlQuery {

 

# Global Cvars

# Database Information

var $link_id  = 0;

var $query_id = 0;

var $affected_rows = 0;

# - Error Information

var $error = "";

var $errno = 0;

# End Global Cvars

 

#############################

# Opens the connection.

# Returns results id.

function query($query_string) {

// do query

$this->query_id = @mysql_query($query_string,$this->link_id);

 

//if screwed up

if (!$this->query_id)

$this->messanger_handler("Mysql Error");

return $this->affected_rows = @mysql_affected_rows();

}

 

}

[teng84]

function checkLogin($username, $password) {

      $sql = new mysqlQuery();

      $sql->mysqlQuery();

      $sql = "select * from users where username='$username' and password='$password' LIMIT 1";

      $results = $sql->query($sql) ? "true" : "false";

     

 

that part of your code

no include for that class note its inside  the function

$sql->mysqlQuery(); <--where is the function mysqlQuery

[clanstyles]

There is the include require_once("class.query.php"); is it. Its called mysqlQuery.

mysqlQuery is the constructor being called. It connects you to the database. It has my sql info in there ct.. It works because I can login using that entire class then it trips out and pulls that when getting there info.

[teng84]

i think i  got it lol

    $sql = new mysqlQuery();

      $sql->mysqlQuery();

      $sql = "select * from users where username='$username' and password='$password' LIMIT 1";

    $results = $sql->query($sql) ? "true" : "false"; <--ERROR FOR SURE

you over right the value of $sql with that query

first you define $sql  as object

then you do this $sql = "select * etc....

[clanstyles]

o rofl thanks I got it lOL

[teng84]

nah... just replace your var name lol

 

$teng = "select * from users where username='$username' and password='$password' LIMIT 1";

[teng84]

ok mark this solved