shivi

Hi all I\'m not sure if MySQL supports triggers, or the syntax... but here\'s what I\'m trying to do: when I delect a record from a table, I want to create an entry into another table with information about the item deleted, pulled from 2 tables (including the one where the delete occured): BidInfo and ItemInfo. So so far I have this: [php:1:0a2b991aad] CREATE TRIGGER trigger AFTER DELETE ON BidInfo FOR EACH ROW EXECUTE PROCEDURE ( INSERT INTO BuyInfo SET ItemID = \'ItemID from BidInfo for deleted row\', Seller = \'UserID from ItemInfo for ItemID\', Buyer = \'CurrBidder from BidInfo\', MaxBid = \'CurrBid from BidInfo for deleted row\'); [/php:1:0a2b991aad] I really don\'t know how to fill in what\'s in the quotes...all these tables are linked by ItemID, the primary key in each. Can anyone help?? Shivi.