REborn

[conquer93]

Help,

I try reborn system for janvier and it login flag error.

WHERE (login_flag0 = 1100);

Server: Msg 156, Level 15, State 1, Line 5
Incorrect syntax near the keyword 'WHERE'.

[janvier123]

remove ;

[*JayKay*]

Originally Posted by conquer93

Help,

I try reborn system for janvier and it login flag error.

WHERE (login_flag0 = 1100);

Server: Msg 156, Level 15, State 1, Line 5
Incorrect syntax near the keyword 'WHERE'.

correct is:

PHP Code:

USE [account];
GO

UPDATE dbo.user_profile
SET login_flag = 0 
WHERE (login_flag = 1100);