[RESOLVED] Insert array into Mysql problem

[grumpy]

I've read the articles on inserting an array into a Mysql, but I can't figure out why my code, below,doesn't work. I'm trying to create an array of zip codes and insert them into a db table. I'm not getting any errors, it just won't insert the data. Any help would be appreciated. Thanks.

//my form

<FORM METHOD="POST" ACTION="do_zipinsert.php">
<b>Combination</b><br><br>
Element 1: <INPUT NAME="zip1" TYPE="TEXT">
<BR>
Element 2: <INPUT NAME="zip2" TYPE="TEXT">
<br>
Element 2: <INPUT NAME="zip3" TYPE="TEXT">
<br>
Element 2: <INPUT NAME="zip4" TYPE="TEXT">
<br>
<INPUT TYPE="Submit" name="add_zips" VALUE"Submit">
</FORM>

//my processing page - do_zipinsert.php

<?php
$ID="6";

$combination[] = ($REQUEST["zip1"].$REQUEST["zip2"].$REQUEST["zip3"].$REQUEST["zip4"]);
print_r ( $combination);

$cats = $combinations;
foreach($cats as $cat) {
$cat_list .= $cat . ' ';
}
;

if ($add_zips == "Submit"){
$sql = "INSERT INTO cat_relations SET
relation_user_id = '$ID',
relation_cat = '$cat_list .'
";
if (@($sql)) {
echo ("Good");
} else {
echo("<p>Error adding cats: " .
mysql_error() . "</p>");
}
}

?>

[halojoy]

<?php

// I prefer you use $_POST, as your form is method="post"
// will pick values one by one into $combination array
$combination[] = $_POST["zip1"];
$combination[] = $_POST["zip2"];
$combination[] = $_POST["zip3"];
$combination[] = $_POST["zip4"];

echo $combination[0]; echo "<br />\n";
echo $combination[1]; echo "<br />\n";
echo $combination[2]; echo "<br />\n";
echo $combination[3]; echo "<br />\n";

[grumpy]

Hi--
I made the changes you suggested, but its still not inserting. Any other ideas? thanks

[bradgrafelman]

If you're trying to store these zipcodes in one field separated by spaces, then I would do this:

Give the INPUT element's the name of "zip[]" - this will create an array when submitted.

Then, simply use [man]implode/man to join the $_POST['zip'] array pieces into a string (using a space as a delimiter).

Might want to make sure that each zip they submitted is valid, too (e.g. is numeric, doesn't contain spaces, etc.).

[grumpy]

The zip[] and implode was the answer. Than you very much.