Insert Array data into MySQL

Hoping someone can help me before all my hair is pulled out. :confused:

I have an array named $arrFeeds:


Array
(
[0] => Array
(
[item id] => 9998


I cannot seem to get the code correct to insert the actual value (9998) into the database. I currently just get 0 inserted.


mysql_query("REPLACE INTO items (item_id) VALUES('$arrFeeds[0][item id]') ")
or die(mysql_error());


I can do echo $arrFeeds[0]['item id']; and get the value 9998.

assign it to the mysql as a variable.

$something = $arrFeeds[0]['item id'];


mysql_query("REPLACE INTO items (item_id) VALUES('$something') ")

Try This One



$i = 0;
$sql_query = "SELECT * FROM tablename";
$result = mysql_query($sql_query) or die(mysql_error());
while($row = mysql_fetch_array($result)){

$id = $row[id];
$person = $row[person];



$arr_id[$i] = $id;
$arr_person[$i] = $person;

$i++;


}

$smarty->assign("id", $arr_id );

PHP Won't parse array values inside double quoted strings like it will normal variables.

Your code won't work, but this, (or seco's) will:

mysql_query("REPLACE INTO items (item_id) VALUES('{$arrFeeds[0][item id]}') ")

Notice the curly braces I've placed around the array value. That's how you do it.

This code doesn't work either. Results in an error:

Parse error: syntax error, unexpected T_STRING, expecting ']' on line 4

I simplified the original post to have only one key in the inner array. There is actually about 17. So I'll work on a loop making a variable o store the data for each.