Array syntax error PHP

Question

I get the error *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 '[0]' at line 1 * when trying to update and email.

$updatelist = explode(",",$Limited);
print_r($updatelist); // echos Array ( [0] => [email protected] [1] => [email protected] [2] => ) 

$totalupdates = count($updatelist)-1;
for ($y = 0; $y < $totalupdates; $y++)
{
  $updatemail = "UPDATE tblusers SET date= '$date' WHERE Email = 'updatelist[$y]'";
  $updatefree = mysql_query($updatemail);

  echo $updatemail;

}

What's wrong with the $updatelist[$y] ? Should it loop through $updatelist[0] to $updatelist[1] ?

Guru · Accepted Answer · 2014-01-11 07:37:15Z

3

change $updatelist[$y] instead of updatelist[$y]

answered Jan 11, 2014 at 7:37

Guru

6191 gold badge4 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

DopeGhoti · Accepted Answer · 2014-01-11 07:37:44Z

1

I think the problem is here:

$updatemail = "UPDATE tblusers SET date= '$date' WHERE Email = 'updatelist[$y]'";

Try this:

$updatemail = "UPDATE tblusers SET date = '$date' WHERE Email = '$updatelist[$y]'";

answered Jan 11, 2014 at 7:37

DopeGhoti

7678 silver badges16 bronze badges

2 Comments

Sarah Over a year ago

Oh thanks! I've been staring at that for a moment now but I haven't realized I missed the "$" sign.

DopeGhoti Over a year ago

No problem! Those sure can sneak up on you if you're not careful.

Guru · Accepted Answer · 2014-01-11 07:50:28Z

0

Try this code:

$updatelist = explode(",",$Limited);
print_r($updatelist); // echos Array ( [0] => [email protected] [1] => [email protected] [2] => ) 
$totalupdates = count($updatelist)-1;
foreach ($updateList as $key=>$val)
{
     $updatemail = "UPDATE tblusers SET date= '$date' WHERE Email = '".$val."'";
     $updatefree = mysql_query($updatemail);
}
 echo $updatemail;

edited Jan 11, 2014 at 7:50

Guru

6191 gold badge4 silver badges12 bronze badges

answered Jan 11, 2014 at 7:48

Nilesh

4401 gold badge6 silver badges22 bronze badges

1 Comment

Nilesh Over a year ago

try to use foreach loop that will give you single value

Damodar Dahal · Accepted Answer · 2014-01-11 07:38:49Z

-1

Try:

  $updatemail = "UPDATE tblusers SET date= '".$date."' WHERE Email = '".$updatelist[$y]."'";

answered Jan 11, 2014 at 7:38

Damodar Dahal

5794 silver badges16 bronze badges

1 Comment

DopeGhoti Over a year ago

I thought at first that was it too, but then realized that single-quotes inside double-quoted strings in PHP aren't special characters. Then I saw the missing $. (:

Collectives™ on Stack Overflow

Array syntax error PHP

4 Answers 4

Comments

2 Comments

1 Comment

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

2 Comments

1 Comment

1 Comment

Related