Kód: Vybrať všetko

IF EXISTS (SELECT unique_id FROM tabulka
      WHERE unique_id = '827011')
      THEN
      UPDATE tabulka
      SET size        = '6',
      color     = '3233'
      WHERE unique_id = '827011'
      ELSE
      INSERT INTO tabulka ( descr,size,unique_id ,colcode_id,color)
      VALUES('fasfasdf','454545','665646','34563456','777777')
      END 

Kód: Vybrať všetko

mysql_query("IF (EXISTS (SELECT unique_id FROM sortiment AS t1
  WHERE t1.unique_id = '{$item['unique']}'))
begin
  UPDATE sortiment
  SET size = '{$item['size']}', price = '{$item['sellingprice']}', 
  u_date = '{$c_date}', u_time = '{$c_time}'
  WHERE unique_id = '{$item['unique']}'
end
else
begin
  INSERT INTO sortiment(descr, size, unique_id ,colcode_id,price,c_date, c_time ) values
  ('{$item['description']}','{$item['size']}','{$item['unique']}','{$item['colcode']}','{$item['sellingprice']}','{$c_date}','{$c_time}')
end 
   }")

Kód: Vybrať všetko

SQL query: Documentation

IF EXISTS (
SELECT unique_id
FROM tabulka
WHERE unique_id = '827011'
)
UPDATE sortiment SET size = '6',
color = '3233' WHERE unique_id = '827011' ELSE INSERT INTO sortiment( descr, size, unique_id, colcode_id, color )
VALUES (
'fasfasdf', '454545', '665646', '34563456', '777777'
)

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IF EXISTS (SELECT unique_id FROM tabulka WHERE unique_id = '827011')
    UPDATE' at line 1 

Kód: Vybrať všetko

INSERT INTO sortiment (descr, size, unique_id ,colcode_id,price,c_date, c_time )
	VALUES ('{$item['description']}','{$item['size']}','{$item['unique']}','{$item['colcode']}','{$item['sellingprice']}','{$c_date}','{$c_time}')
	ON DUPLICATE KEY UPDATE size = '{$item['size']}', price = '{$item['sellingprice']}', u_date = '{$c_date}', u_time = '{$c_time}';