Can't insert into table

[Anon]

I have a HTML form with the following code
<?
$db_user = "";
$db_pass = "";
$db_name = "";

mysql_connect("",$db_user,$db_pass);

mysql_select_db ($db_name);

if ($submit){

$z = mysql_db_query ($db_name, "SELECT prod_id FROM producers where name = '$name'");
$k = mysql_fetch_array ($z);

$x = mysql_db_query ($db_name, "INSERT INTO documentaries (title, description, audio_link, image_link, series_name, category, keywords, prod_id)
VALUES ('$title', '$description', '$audio', '$image', '$series', '$category', '$keywords', $k)");
echo mysql_error();
}
?>

I tried to get the prod_id from a table by using a select form where user choose the producer name and then put it into documentaries table.
It gives me the following error:
Unknown column 'Array' in 'field list'

Please help me

[Anon]

$k is an array of the select statement you should use:

while ($k = mysql_fetch_array($z)) {
$prod_id = $k["prod_id"];

$x = mysql_db_query ($db_name, "INSERT INTO documentaries (title, description, audio_link, image_link, series_name, category, keywords, prod_id)
VALUES ('$title', '$description', '$audio', '$image', '$series', '$category', '$keywords', $prod_id)");
echo mysql_error();
}

[Anon]

Thanx,

it worked.