צריך עזרה אם ARRAY ו MYSQL INSERT
$link=mysql_connect("$host","$user","$pass"); // database selection mysql_select_db("$database"); /* $column as DB fields names */ $column = array ("Item","art_no","ItemPrice","ItemWeight","Quantity"); $arr = array ("Name1","SKU1","12600","90","1","Name","SKU","99","10","2"); $i=0; foreach($arr as $v) { /* Try take from $arr 0-4 values and insert into table $column[$i]=$v */ if ($i < 4) { $i=$i+1; }else { $i=0; } $result = mysql_query("INSERT INTO shopping_card ($column[$i]) VALUES (´$v´)"); }//end for each Problem: the data insert in DB like each value to each row (8 rows affected)
$link=mysql_connect("$host","$user","$pass"); // database selection mysql_select_db("$database"); /* $column as DB fields names */ $column = array ("Item","art_no","ItemPrice","ItemWeight","Quantity"); $arr = array ("Name1","SKU1","12600","90","1","Name","SKU","99","10","2"); $i=0; foreach($arr as $v) { /* Try take from $arr 0-4 values and insert into table $column[$i]=$v */ if ($i < 4) { $i=$i+1; }else { $i=0; } $result = mysql_query("INSERT INTO shopping_card ($column[$i]) VALUES (´$v´)"); }//end for each Problem: the data insert in DB like each value to each row (8 rows affected)