Trigger

[Phil Newell]

Sequel pro wont let me add multiple If statements inside a trigger. It says there is a syntax error.

if (old.tradePackQty <> new.tradePackQty) then

INSERT INTO logs(user_id, tableName, tableKey, description, tableField, oldValue, newValue) VALUES (99, 'products', OLD.id, 'Updated Product', 'tradePackQty', old.tradePackQty, new.tradePackQty);

end if;

if (old.tradePrice <> new.tradePrice) then

INSERT INTO logs(user_id, tableName, tableKey, description, tableField, oldValue, newValue) VALUES (99, 'products', OLD.id, 'Updated Product', 'tradePrice', old.tradePrice, new.tradePrice);

end if;

Any idea how to change this?