php update如果没有数据,PHP MYSQL UPDATE如果存在或INSERT如果没有？

我不知道这是否甚至远程正确。我有一个类，我想更新数据库，如果字段当前存在或插入，如果他们不。复杂的是，我做一个加入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;

}}

提前致谢。