3 replies to this topic

[mmo-dev]

 $result1 = mssql_query("SELECT convert(varchar, id)
  FROM tbl_rfaccount WHERE password = convert(binary, 'blach')");

while($temp = mssql_fetch_row($result1)){
    $hold = (string) $temp[0];
    echo "SELECT serial FROM tbl_UserAccount WHERE id = convert(binary, '$hold')";
    $query1 = mssql_query("SELECT serial FROM tbl_UserAccount WHERE id = convert(binary, '$hold')");

with error:

 Warning: mssql_query() [function.mssql-query]: message: Unclosed quotation mark after the character string 

[semprance]

Are there any quote or double-quote characters in the $hold string?

[mmo-dev]

nope the user name that $hold is inputting is A1T1 and A1T1 works when its directly inputted so its something else with $hold

[mmo-dev]

ok problem is fixed :)