public static function updateAssist($id) { $sql = 'UPDATE beauty_canon SET assist = assist+1 WHERE id = :bc_id'; $model = new CosBeautyCanon(); return $model->getWriteConnection()->execute($sql, ['bc_id' => $id]); }
public static function updateAssist($id) { $sql = 'UPDATE cos_beauty_canon SET assist = (SELECT COUNT(*) FROM cos_beauty_canon_assist WHERE beauty_canon_id=cos_beauty_canon.id) WHERE id = :bc_id'; $model = new CosBeautyCanon(); return $model->getWriteConnection()->execute($sql, ['bc_id' => $id]); }