php updating current row during w while loop

Question

Hi all im trying to update the current row im putting through mysql. The line which is wrong is

mysql_query("UPDATE wp_postmeta SET meta_value = '$newimg', converted = 1 WHERE post_id = $info['post_id']");

if I comment this out all is fine, is there a problem with this specific line or is it a problem with trying to do this during a loop?

Error:

Parse error: syntax error, unexpected '' (T_ENCAPSED_AND_WHITESPACE), expecting identifier (T_STRING) or variable (T_VARIABLE) or number (T_NUM_STRING) in /home2/mxadam/public_html/upimages.php on line 19

code:

$data = mysql_query("SELECT post_id, meta_value FROM wp_postmeta WHERE post_id =   1926914") 
or die(mysql_error()); 
Print "<table border cellpadding=3>"; 
Print "start";
while($info = mysql_fetch_array( $data )) 
{ 
$newimg = itg_fetch_image($info['meta_value']);
echo $newimg;
mysql_query("UPDATE wp_postmeta SET meta_value = '$newimg', converted = 1 WHERE post_id = $info['post_id']");
Print "<tr>"; 
Print "<th>ID:</th> <td>".$info['meta_postid'] . "</td> "; 
Print "<th>VALUE:</th> <td>".$info['meta_value']. "</td> "; 
Print "<th>DONE:</th> <td>YES</td> "; 
} 
Print "End";
Print "</table>"; 
}

Marc B · Accepted Answer · 2014-03-04 19:56:22Z

4

Basic PHP strings: You cannot use quoted array keys within a double-quoted string unless you use the {} extended syntax:

$arr['foo'] = 'bar';

echo "$arr['foo']"; // incorrect
echo "$arr[foo]"; // correct
echo "{$arr['foo']}"; // correct

answered Mar 4, 2014 at 19:56

Marc B

362k44 gold badges433 silver badges508 bronze badges

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

Collectives™ on Stack Overflow

php updating current row during w while loop

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related