Important: Error in Database {Array}

[IMP_TWI]

So my problem is a bit simple but I can't seem to figure it out. My code will be posted below but what basically happens is that when it inserts the data into the database it shows up in db as Array.

      $vcity = "SELECT * FROM user_characters WHERE nickname='$varvictim'";
      $vcity = mysql_query($vcity);
      $vcity = mysql_fetch_array($vcity);
      $vcity = $vcity['city'];

  $witness = "SELECT nickname FROM user_characters WHERE city='$vcity'";
  $witness = mysql_query($witness);
  $tempwitness = mysql_fetch_array($witness);





    $query= "INSERT INTO $prefix.witnesses (`id`, `victim`, `killer`,
`witnessed`,`submitted`,`witness`, `statement`) VALUES
('','$varvictim','$attacker', '0', '0', '$tempwitness', 'You witnessed $attacker killing $varvictim!')";

$result=mysql_query($query) or die(mysql_error());
                

The field that show's up as Array is the $tempwitness field that is under Values.

[IMP_TWI]

Corrected the error, Now it displays a correct name in database but it's not inserting the multiple arrays into the Database.

[nemonoman]

That's because $tempwitness is an array, not a single value. Maybe you mean the first element of that array?

INSERT INTO table blahblah
VALUES ('$tempwitness[0]', blahblah

maybe you want to insert the contents of the array as string? Then convert the array to a string:

$witnessstring=implode(' - ', $tempwitness);

Then INSERT INTO table blahblah
VALUES ('$witnessstring', blahblah