[SOLVED] UPDATE table

[cliftonbazaar]

$sql = "UPDATE players
    SET '$adventure['image']'='{$player[$adventure['image']]}'
    WHERE characterName='{$player['characterName']}'";

 

After fiddling with the code I have worked out that '$adventure['image']' is the problem.  What is the correct syntax?  (and yes, the variable is the correct column name)

[PFMaBiSmAd]

Single-quotes around a value makes it a sql string, not an sql identifier. Remove the single-quotes that are around '$adventure['image']'

 

You also need to put $adventure['image'] inside of {}, like the other php array variables are in that php string.

 

[cliftonbazaar]

Thanks for that; still learning