[INFO]Total users registred -> sql
#8

Quote:
Originally Posted by VincentDunn
Посмотреть сообщение
Why would you select everything? A waste of memory.

pawn Код:
format(query, sizeof(query), "SELECT COUNT(*) FROM `%s`", TABLE_NAME);
    mysql_query(query);
   
    mysql_store_result();
   
    new
        total_users = mysql_fetch_int();

    mysql_free_result();
Or whatever function gets the integer from the field.
Thanks
Reply


Messages In This Thread
[INFO]Total users registred -> sql - by TheBluec0de - 20.06.2012, 19:09
Re: [INFO]Total users registred -> sql - by Pizzy - 20.06.2012, 19:14
Re: [INFO]Total users registred -> sql - by Mandrakke - 20.06.2012, 19:14
Re: [INFO]Total users registred -> sql - by TheBluec0de - 20.06.2012, 19:16
Re: [INFO]Total users registred -> sql - by TheBluec0de - 20.06.2012, 19:56
Re: [INFO]Total users registred -> sql - by TheBluec0de - 20.06.2012, 20:09
Re: [INFO]Total users registred -> sql - by ReneG - 20.06.2012, 20:24
Re: [INFO]Total users registred -> sql - by TheBluec0de - 20.06.2012, 20:29

Forum Jump:


Users browsing this thread: 1 Guest(s)