public static function updateTitleGrpInfo($seedKeyword, $shortTitle, $grpId, $aid, $whTitle = '') { if (empty($seedKeyword) || empty($shortTitle)) { return null; } $dbw = DbUtils::getDbw(); $query = "UPDATE leonard.leo_titles t \n\t\t SET \n\t\t\tdup_grp_id = " . $dbw->addQuotes($grpId) . " \n"; if (!empty($aid) && $aid > 0) { $query .= ", wh_title = " . $dbw->addQuotes(str_replace(' ', '-', $whTitle)) . " \n" . ", wh_aid = " . $dbw->addQuotes($aid) . " \n"; } $query .= " WHERE " . " t.seed = " . $dbw->addQuotes($seedKeyword) . " \n" . " AND t.short_title = " . $dbw->addQuotes($shortTitle) . " \n\t\t AND t.status = 'A' "; return DbUtils::exDbW($query); }