[SOLVED] Only displaying last result in array

[hansman]

code

$zips = $_POST['zips'];

$zipsextracted = explode(",", $zips);

mysql_connect("-----", "--------", "------");
mysql_select_db("--------") or die( "Unable to select database"); 
foreach($zipsextracted as $zip) {
"INSERT INTO `Zips_To_Company` (`id`, `company_id`, `zip_id`) VALUES ('', '1', '$zip')";
}

 

echo $zipsextracted; ------Displays "array"

 

when i turn the query into a variable it only shows the last item in the array.

[DarkWater]

You can't echo an array to begin with, so it just shows "Array" when you try to echo it.  Now, what happens with the query exactly, and how is $_POST['zips'] formatted?

[hansman]

$_POST['zips'] = 10567,10567......

 

and the query dosent even work, nothing put into the db

[hansman]

$_POST['zips'] = 10567,10567......

 

and the query dosent even work, nothing put into the db

[Jibberish]

Just a quick question just in case, are you actually running the query, as cant really tell from that code

 

 

i.e

$zips = $_POST['zips'];

$zipsextracted = explode(",", $zips);
mysql_connect("-----", "--------", "------");
mysql_select_db("--------") or die( "Unable to select database"); 
foreach($zipsextracted as $zip) {
$sql = "INSERT INTO `Zips_To_Company` (`id`, `company_id`, `zip_id`) VALUES ('', '1', '$zip')";
mysql_query($sql)or die('Error, insert query failed');
}

[hansman]

haha im stupid forgot to query it, thank you