function val_md_day($col,$val,$row, $instanceName) { // Delete image file if it already existed $query = "select md_day from ess where md_day = :md_day"; $queryParams = array('md_day' => $val); $stmt = $this->Editor->doQuery($query,$queryParams); if($row = $stmt->fetch(PDO::FETCH_ASSOC)) { // Create custom validation message and return false $this->Editor->showDefaultValidationMsg = false; $this->Editor->addTooltipMsg('There exist a record with date ' . $val . ' so it can not be added but edited. ' ); return false; } else { return true; } } // validate function if value already exist function checkDomain($col,$val,$row) { $query = "select domain from ".TBL_MAIN." where domain = '$val'"; $result = mysql_query($query); if (mysql_num_rows($result) == 0) { return $val; } else { $this->Editor->retArr[] = array('where' => 'javascript', 'value' => 'alert("Sorry this dance name already exists in the db");'); return false; } }