MSQL Help - Returning Value

PHP Code:

---

$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

well on some of those lines you are missing things.

PHP Code:

---

$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'"); 


---

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

PHP Code:

---

$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?

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