[SOLVED] What am I doing wrong?

[galvin]

I have this very simple array called $answers...

 

Array
(
    [0] => cat
    [1] => dog
    [2] => monkey
)

 

I simply want to loop through the elements in that array and see if they match the answers I have stored in a database.  The code below works if I remove the 4th line of the query (So that line has to be the problem) but I need the 4th line to only update where there is a match. 

With that line kept in, I keep getting unexpected TVARIABLE on line 31 which is that line. What is wrong with that line? Anyone?

 

for ($i=0; $i < count($answers); $i++)  {


				$query = "UPDATE listitems
				SET timesguessed = 7
				WHERE listid = {$_SESSION['listid']}
				AND item = {$answers[i]}";

				$sendanswers = mysql_query($query, $connection);
				if (!$sendanswers) {
				die("Database query failed: " . mysql_error());
				} else {

				}


}

[Maq]

Don't you mean?

 

$answers[$i]

 

 

[galvin]

Son of a b*TCH!!!    I'm such an idiot.  Thank you Maq!

[Maq]

Son of a b*TCH!!!  >  I'm such an idiot.  Thank you Maq!

 

Hehehe...