[php_mysql] Usng variables and sprintf

[Charlie Markwick]

Given:-

$strFields = 'Gender=%s, UserName=%s';
$strValues = '"Male","charlie","nhy01"';

why does:-

$strUpdateSQL = sprintf('UPDATE UserTable SET ' . $strFields . ' WHERE
ID=%s', "Male","charlie","nhy01"); 

work, while:-

$strUpdateSQL = sprintf('UPDATE UserTable SET ' . $strFields . ' WHERE
ID=%s', $strValues);  

doesn't?

Charlie