AppGini Community Forums

Code: Select all

function Tag_before_update(&$data, $memberInfo, &$args) {
	//Check for duplicate name
	$nomenew = $data['Nome'];
	$check = sql("select * from Tag where Nome='$nomenew'", $eo);

	if ($check->num_rows == 0) {
		//Retrieve current name for REPLACE query
        	$selectedID = makeSafe($data['selectedID']);        
        	$result = sql("select * from Tag where id='{$selectedID}'", $eo);
        
                if ($result->num_rows > 0) {
                	while ($row = $result->fetch_assoc()) {
                              $nomeold = $row['Nome'];    
                	}
       		}

		sql("UPDATE Clients SET Tag = REPLACE(Corsi, '$nomeold', '$nomenew')", $eo);
	}
}