value update by using class

[arvind vohra]

function changeusername($username)
	{
		$data['username']	=	$username;
		$ans = $this->db->update_query("indiagren_admin",$data,"username!=' '");
		echo "ANS".$ans;
	}


function update_query($filename,$data,$where)
	{
		$sql= "UPDATE ".$filename." SET ";		
		foreach ($data as $key=>$value)
		{
			$sql.=$key."=.$value";
		}
		
		$sql = rtrim($sql) . ' WHERE '.$where.';';
		echo " ".$sql."<br>";
		$run = mysql_query($sql) or die (mysql_error());

	}

give the error on update query :-

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE username!=' '' at line 1

[Rabbit]

Output the sql string and show us what that looks like.