problem with class syntax...

[googlehunter]

hi,

 

I am writing a class with the following code:

 

 

class Member{

var $username;
var $membertable;
var $postpass;

//instantiate variables
function Member($username,$postpass,$membertable){

$this->username=$username;
$this->membertable=$membertable;
$this->postpass=$postpass;

}

//check to see if login information is valid
function checkMembership(){

$checkpass=mysql_query("select * from $this->membertable where username='$this->username'") or die("could not validate user");
$checkpass2=mysql_fetch_array($checkpass);



	if($checkpass2["password"]==$this->postpass){

		$_SESSION['memberid']=$checkpass["memberid"];
		return true;
	}

	elseif ($this->postpass!=$checkpass2["password"] || empty($this->postpass) || empty($this->username))
	{

		return false;

	}



}


//end class
}

 

when I run the script it dies at the mysql_query line.  if I change the $this->membertable to the actual table name it works but when I switch it back to $this->membertable it does not work.  $this->membertable is defined and has a value.

 

what is the problem with that code.

 

thanks in advance.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

[papaface]

Try this for all of your queries:

username='".$this->username."'"