SQL Registring player system by ID
#4

pawn Код:
db_query(Database, "CREATE TABLE IF NOT EXISTS `USERS` (`ID` AUTO_INCREMENT,`NAME`, `PASSWORD`, `IP`, `SCORE`, `CASH`, `ADMIN`, `VIP`)");
It always return me nuber 0 when trying to get ids count his way:
pawn Код:
format(Query, sizeof(Query), "SELECT `NAME` FROM `USERS` WHERE `NAME` = '%s' ",name);
                Result = db_query(Database, Query);
                if(db_num_rows(Result))
                {
                    new Field[ 20 ];
                    db_get_field_assoc(Result, "ID", Field, 30);
                    format(Query, sizeof(Query), "**%s has registred making the total of %i players registred.", name, Field);
                    SendClientMessageToAll(0xFFFFFFAA,Query);
                }
Reply


Messages In This Thread
SQL Registring player system by ID - by [WSF]ThA_Devil - 21.04.2012, 08:07
Re: SQL Registring player system by ID - by [MG]Dimi - 21.04.2012, 09:52
Re: SQL Registring player system by ID - by [WSF]ThA_Devil - 21.04.2012, 10:20
Re: SQL Registring player system by ID - by [WSF]ThA_Devil - 21.04.2012, 10:56

Forum Jump:


Users browsing this thread: 2 Guest(s)