Re: Error in SQL query

[Robin John]

Hello Peter,

Thank you for pointing in the right direction. Took me a while to understand Procedures but was definitely worth it. Also I learnt some other complexities of a database. Here is the query that worked for me:
DELIMITER $$
CREATE DEFINER=`root`@`localhost` PROCEDURE `AddText`()
BEGIN


DECLARE post_status INT DEFAULT 0;

DECLARE post_counter INT;

DECLARE post_total INT;

DECLARE post_currentId INT;
SELECT MIN(counter) FROM wp_text INTO post_counter;


SELECT MAX(counter) FROM wp_text INTO post_total;
WHILE(post_counter IS NOT NULL AND post_counter<=post_total)
DO
SELECT Id FROM wp_text WHERE counter = post_counter INTO post_currentId;

SELECT Active from teksten WHERE Id = post_currentID INTO post_status;

IF post_status = 1 THEN

UPDATE wp_text
set Active = "publish"
WHERE counter = post_counter;

ELSE

UPDATE wp_text
set Active = "pending"
WHERE counter = post_counter;

END IF;

SET post_counter = post_counter + 1;

END WHILE;

END$$
DELIMITER ;