Store procedure Where in () php implode() function

[achille84]

Hi

 

i have a form where user can select multiple checkboxes and post it to a page

 

// some validation here

$myboxes=array();   

$myboxes = $_POST['boxes'];

$argument=(implode("," ,  $myboxes));

$rs = mysql_query("call orderByID($argument)");

//while loop to print out

 

 

and my store procedure

 

 

DROP PROCEDURE IF EXISTS `orderByID`$$

 

CREATE DEFINER=`root`@`localhost` PROCEDURE `orderByID`(id VARCHAR(2048))

BEGIN

 

SET  @QUERY =CONCAT('SELECT

 

//some sql here

 

        WHERE orderId IN (',id,') AND stock_1>0

        UNION ALL

          SELECT CASE WHEN

 

//some sql here

 

        WHERE orderId IN (',id,') AND stock_2>0) O  GROUP BY productId');

PREPARE stmtInsert FROM @QUERY;

EXECUTE stmtInsert;

    END$$

 

DELIMITER ;

 

 

 

problem is store procedure works fine for 1 selected check-box,but for multiple boxes it fails..

may be because of WHERE orderId IN (',id,') condition ... (implode("," ,  $aDoor)) function returns a string as far as i know..

 

 

thanks

[fenway]

Why is this even an SP?