[dimkasmir]

I am getting

Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in C:\root\www\trading.php on line 10

from the following line of code:

PHP Code:

$order = mysql_query("UPDATE geocoins SET gid = $i WHERE name = $arrayn['0'] "); 

Any ideas?

[mdhall]

Try this ....

PHP Code:

$order = mysql_query("UPDATE geocoins SET gid = '$i' WHERE name = '$arrayn['0']' "); 

[landing]

The following should work also

PHP Code:

$order = mysql_query("UPDATE `geocoins` SET `gid` = '$i' WHERE `name` = '$arrayn[0]'"); 

[jtanmay]

i hope u have solved this one.

but if not, check if you have missed ";" some where.
if you have started session but you have spaces before it.
you may have included a file, and that file could have extra spaces at the end of file
and might be some where you have forgot to close " or ' in code.

[Nico]

The error comes from these 2 single quotes inside the double quoted string.

Landing's solution should work. And an alternative way of doing it would be:

PHP Code:

$order = mysql_query("UPDATE geocoins SET gid = $i WHERE name = {$arrayn['0']} ");