MySQL: Ophalen van een andere rij

--
-- Table structure for table `category`
--

CREATE TABLE IF NOT EXISTS `category` (
`id_category` int(11) NOT NULL auto_increment,
`title` varchar(256) NOT NULL,
`order_number` int(11) default NULL,
PRIMARY KEY (`id_category`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=34 ;

--
-- Dumping data for table `category`
--

--
-- Table structure for table `question_response`
--

CREATE TABLE IF NOT EXISTS `question_response` (
`id` int(11) NOT NULL auto_increment,
`question` varchar(256) NOT NULL,
`response` text character set utf8 collate utf8_unicode_ci NOT NULL,
`category_id` int(11) default NULL,
`order_number` int(11) default NULL,
PRIMARY KEY (`id`),
KEY `fk_question_response_Category` (`category_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=18 ;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `question_response`
--
ALTER TABLE `question_response`
ADD CONSTRAINT `question_response_ibfk_1` FOREIGN KEY (`category_id`) REFERENCES `category` (`id_category`) ON DELETE CASCADE ON UPDATE NO ACTION;

DROP TRIGGER IF EXISTS saldoupdate
DELIMITER //
CREATE TRIGGER saldoupdate AFTER INSERT ON saldotabel
FOR EACH ROW BEGIN
UPDATE usertabel SET saldo = saldo + NEW.saldowijziging WHERE userID = NEW.userID;
END
//
DELIMITER ;