Need help with trying to make UPDATE write data to the database

[Redlightpacket]

Here is my error message I get.

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[1] = 'listen'' at line 1

 

Some how it won't write data in the first and next and next fields in my database table.

 

 

//Trying to make this data go into the database table.

//SET
$column=array("listen","date","message");
$value=array("listen","date","message");


//WHERE
$column2=array("video","listen","date");
$value2=array("video","listen","date");



$counts = 1;
while($counts < 4)
{
$counts = 0 + $counts;	
$n = 1;
$n2 = 1;
$n = 0 + $n;
$n2= 0 + $n2;

$result =  mysql_query("UPDATE _0_sermon_data_file SET $column[$n] = '$value[$n]' WHERE column2[$n2] = '$value2[$n2]'")
or die(mysql_error());


}


///////////////////////////////////////////////////////////////////////////////////////////////////////////

 

[avvllvva]

try proper string quotes

$result =  mysql_query("UPDATE _0_sermon_data_file SET ".$column[$n]." = '".$value[$n]."' WHERE ".column2[$n2]." = '".$value2[$n2]."'")

[cags]

Since column2 is an array in your script, not a table in your database you require a dollar sign to signify it as a variable.

 

WHERE column2[$n2]