[mprofitt]

format(string, sizeof(string), "UPDATE PlayerInfo SET Password = '%s' WHERE PlayerName = '%s'", Password, PlayerName);
mysql_query(string);

simple as that...depending on what plugin you use, they all have slightly different context.