Database query failed because 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 '=
public function update(){ global $database; $sql = "UPDATE users SET "; $sql .= "FullName='".$database->mysqlPrep($this->fullName)."',"; $sql .= "RoleID='". $database->mysqlPrep($this->roleID) ."', "; $sql .= "UserName='". $database->mysqlPrep($this->userName) ."',"; $sql .= "Email='". $database->mysqlPrep($this->email) ."', "; $sql .="Password='". $database->mysqlPrep($this->password)."' "; $sql .= "WHERE ID=". $database->mysqlPrep($this->id); $database->query($sql); return ($database->affectedRows() == 1) ? true:false; }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)