here is error :
i try this but dont work:
can someone help?
Code:
string(339) "SELECT [ICODE]p[/ICODE].[ICODE]id[/ICODE], [ICODE]p[/ICODE].[ICODE]name[/ICODE], [ICODE]p[/ICODE].[ICODE]level[/ICODE], [ICODE]p[/ICODE].[ICODE]vocation[/ICODE], [ICODE]p[/ICODE].[ICODE]town_id[/ICODE], [ICODE]p[/ICODE].[ICODE]lastlogin[/ICODE], [ICODE]gm[/ICODE].[ICODE]rank_id[/ICODE], [ICODE]po[/ICODE].[ICODE]player_id[/ICODE] AS [ICODE]online[/ICODE] FROM [ICODE]players[/ICODE] AS [ICODE]p[/ICODE] LEFT JOIN [ICODE]guild_membership[/ICODE] AS [ICODE]gm[/ICODE] ON [ICODE]p[/ICODE].[ICODE]id[/ICODE]=[ICODE]gm[/ICODE].[ICODE]player_id[/ICODE] LEFT JOIN [ICODE]players_online[/ICODE] AS [ICODE]po[/ICODE] ON [ICODE]p[/ICODE].[ICODE]id[/ICODE]=[ICODE]po[/ICODE].[ICODE]player_id[/ICODE] WHERE [ICODE]p[/ICODE].[ICODE]account_id[/ICODE]='5' ORDER BY [ICODE]p[/ICODE].[ICODE]level[/ICODE] DESC"
(query - SQL error)
Type: select_multi (select multiple rows from database)
Code:
ALTER TABLE [ICODE]accounts[/ICODE] ADD [ICODE]gm.rank_id [/ICODE] int NOT NULL;
ALTER TABLE [ICODE]field list[/ICODE] ADD [ICODE]gm.rank_id [/ICODE] int NOT NULL;
can someone help?