Sorry, forgot to list the trigger duh..

delimiter //
CREATE TRIGGER mytrigger
AFTER INSERT ON test
FOR EACH ROW

BEGIN

DECLARE Col CHAR(55);

IF NEW.type = 0 THEN
SET Col = 'news';
ELSE
SET Col = 'pictures';

END iF;


UPDATE trigger_test SET Col = Col + 1 WHERE `userid` = NEW.id;

END;//
delimiter ;