check box loop

[siriusdave]

i have this bit of code

<div class="content_text_right" style="width: 80%;">';
$num = 0;
 foreach ($sopchannel as $sc) {
 echo'<input type="checkbox" name="sopcastch'.$num.'" value="'.$sc['value'].' | "> '.$sc['Station'].'<br>';
$num ++;
 } 
echo'</div>

which loop the info from database and give the checkbox name a number

ie sopcast1 sopcast 2 ect

then i have this bit of code

$sopcast1 =	$_POST['sopcastch1']; 
$sopcast2 =	$_POST['sopcastch2']; 
$add_news_query = mysql_query("INSERT INTO ". $tbl_prefix ."footytv SET sopcastch = '".$sopcast1."".$sopcast2."'");   

which i need it to insert in to the datbase in table footytv col sopcastch

value eg. 1|2|3
which i gets from the check boxes
but it is only adding the last one

please help ...

thank you

siriusdave

[cahva]

Well if you just want to compine all selected sopcastch then you should do it like this:

Creating the form

echo'<input type="checkbox" name="sopcastch[]" value="'.$sc['value'].'"> '.$sc['Station'].'<br>';

Now the checkboxed sopcastch can be found as an array in $_POST['sopcastch'].

And then the query:

$sopcast = !empty($_POST['sopcastch']) ? implode('|',$_POST['sopcastch']) : '';
$add_news_query = mysql_query("INSERT INTO ". $tbl_prefix ."footytv SET sopcastch = '".$sopcast."'");

[julietsstars]

I just posted a similar sinerio but with dropdowns. I have a different number of dropdowns that are added per product (which is added by the end user - so there could be multiples) and in the admin portion of the page where you can view the users entries there is a dropdown for each that the admin would reject and why. The "whys" are in the dropdown.

I can only get one value as well. Do you suggest that the way above could be used for dropdown values as well?