SQL field

[pinehead18]

$sql = "UPDATE users SET $pic='$newname', pic='true' WHERE user='$name'";

That is my code..

What i want to do is for $pic to eqaul the field that i want updated at that specific time. However it seems that sql just ignores it.

Any ideas?

Thank you
Anthony

[LordShryku]

Try seperating the vars from the string

$sql = "UPDATE users 
           SET ".$pic."='".$newname."', 
               pic='true' 
         WHERE user='".$name."'";