我不确定这是否正确。我有一个类,想要在字段存在时更新数据库,如果它们不存在则插入。问题是我正在连接3个表(set_colors、school_art和baseimage)。
非常感谢任何帮助。
以下是我的代码:
非常感谢任何帮助。
以下是我的代码:
public function set_layer_colors($value) {
global $db;
$result_array = mysql_query("
IF EXISTS(SELECT * FROM set_colors WHERE school_art_id = '{$value}')
UPDATE set_colors (school_art_id, baseimage_id, sub_folder, layer)
SELECT school_art.id, baseimage.id, baseimage.sub_folder, baseimage.layer
FROM school_art
JOIN baseimage ON baseimage.base_folder = school_art.series_code
WHERE baseimage.image_type = 'B' ORDER BY school_art.id
ELSE
INSERT INTO set_colors (school_art_id, baseimage_id, sub_folder, layer)
SELECT school_art.id, baseimage.id, baseimage.sub_folder, baseimage.layer
FROM school_art
JOIN baseimage ON baseimage.base_folder = school_art.series_code
WHERE baseimage.image_type = 'B' ORDER BY school_art.id
");
return $result_array;
}
psw
与password
。此外,在ON DUPLICATE KEY UPDATE子句中,你没有指定role
字段(我不确定这是否重要)。 - Tash Pemhiwa