problems with foreach

[mstembri]

I'm having a little trouble the following script to work...

Here's the Form:

<form action="insert.phtml" method="post">
<SELECT NAME="imagelinks[]" MULTIPLE SIZE="8">
    <OPTION VALUE="100">None</OPTION>
    <OPTION VALUE="2">zxcv</OPTION>
    <OPTION VALUE="4">asdf</OPTION>
</SELECT> 
<input type="hidden" name=model value="88kx500">
<input type="submit">
</form>

Here's the Insert script:

	foreach ($imagelink as $value) {
		$mValues.="($value),";
	}
	$mValues = substr($mValues,0,-1); // remove last comma
	$sql = "INSERT INTO imagelinks (model, imagelink) VALUES ('$model', '$mValues')";
	echo $sql;
	//$result = mysql_query($sql);

Here's the Error:

Warning: Invalid argument supplied for foreach() in insert.phtml on line 14
INSERT INTO imagelinks (model, imagelink) VALUES ('88kx500', '')

Line 14 is the foreach line.

Your help is appreciated!

[TWTCommish]

I don't know if this matters, but your form field is called "$imagelinks[]", and your foreach loop uses "$imagelink[]". without the "s" at the end.

[mstembri]

Wish that were the problem, I put the sample form in my example as the real one is generated with javascript, and is complex. It does pass an array to the sql script ($imagelink[])

[freddydoesphp]

Its quite obvious that your javascript is not operating properly, did you try and print out the count() of the array on the sql page.

Something like

<?
if(count($imagelink) > 0) {
    foreach ($imagelink as $value) {
        $mValues.="($value),";
        }
    }
else {
    print "My form is not passing an array properly";
    }    
?>