MSQL Help - Returning Value

[Gunner54]

$query = mssql_query("UPDATE Character SET Sex = '$Sex' WHERE Name = '$Char'"
$CID = mssql_query("SELECT CID FROM Character WHERE Name = '$Char'");
$query = mssql_query("DELETE FROM CharacterItem WHERE CID = '$CID'"

Obviously i thought $CID would = the value selected. But Obviously it doesnt. How can i make $CID = the SELECT CID FROM Character WHERE Name = '$Char' Value?

Thank You

[dclamp]

well on some of those lines you are missing things.


$query = mssql_query("UPDATE Character SET Sex = '$Sex' WHERE Name = '$Char'");
$CID = mssql_query("SELECT CID FROM Character WHERE Name = '$Char'");
$query = mssql_query("DELETE FROM CharacterItem WHERE CID = '$CID'");

[penagate]

mssql_query, if successful, returns a result set, not a single result.

$resultset = mssql_query("SELECT CID FROM Character WHERE Name = '$Char'");

while ($row = mssql_fetch_assoc($resultset))
print_r($row);


More examples on the manual page.
http://php.net/manual/en/function.mssql-query


dclamp—that post is thoroughly unhelpful—missing what, exactly?

[dclamp]

there was some parenthesis missing, some quote marks, and semi-colon