[RESOLVED] Query

[raouleduke]

I have a lil problem, may be something that's easy that I am just not seeing here but maybe someone can help me. The $report_campaign variable is coming from a multiple form select box. it will be all integers ie (1,2,3,4,5,6,7,8)

$report_campaign = implode(",",$_POST['report_campaign']);
$temp = explode(",",$report_campaign); 
foreach( $temp AS $key => $val ){
$key = stripslashes( $val );

Trying to turn it into part of a query where it goes something like below for each of the selected value of the form.

(report_campaign = '$report_campaign' OR report_campaign = '$report_campaign' OR report_campaign = '$report_campaign' etc......

thank in advance if anyone can help.

[laserlight]

Well... if you already have it in the form (1,2,3,4,5,6,7,8), then it is perfect for the query. You just use an IN clause instead, e.g., WHERE report_compaign IN (1,2,3,4,5,6,7,8).

The only catch is that you have to be sure that it really is in the correct format otherwise you are vulerable to SQL injection. A regular expression check might suffice.

[raouleduke]

Thanks, jesus I should have saw that. Must have been a bad mental block that day. Thank you very much.