Hi.
When trying to run this line of code: (line 171, $ipsel3)
$ipselect1 = mssql_query("SELECT * FROM [RF_USER].[dbo].[tbl_UserAccount] WHERE [createip]='$_POST[ip]'");
while ($myrow=mssql_fetch_array($ipselect1))
{
$ipsel2 = mssql_query("SELECT * FROM [RF_USER].[dbo].[tbl_UserAccount] WHERE [serial]='$myrow[serial]'");
$ipselect2 = mssql_fetch_array($ipsel2);
if($ipselect2['id'] != '')
{
$ipsel3 = mssql_query("SELECT * FROM [RF_USER].[dbo].[tbl_rfaccount] WHERE [id]=CONVERT(binary, '$ipselect2[id]')");
$ipselect3 = mssql_fetch_array($ipsel3);
I get this error.
Warning: mssql_query() [function.mssql-query]: message: Unclosed quotation mark after the character string 'test1'. (severity 15) in C:\AppServ\www\Update\e\accmanager.php on line 470
Warning: mssql_query() [function.mssql-query]: message: Incorrect syntax near 'test1'. (severity 15) in C:\AppServ\www\Update\e\accmanager.php on line 470
Warning: mssql_query() [function.mssql-query]: Query failed in C:\AppServ\www\Update\e\accmanager.php on line 470
Warning: mssql_fetch_array(): supplied argument is not a valid MS SQL-result resource in C:\AppServ\www\Update\e\accmanager.php on line 471
Can someone please tell me where i made a mistake ? Thanks.