jeudi 3 septembre 2015

MYSQL,stating with errors :/

so i readed around 10000 tutorials about mysql and how to use,and i'm trying to create a database,and save just money,and started with errors.. :/
so i have wamp server,and i get errors when i go to phpmyadmin (localhost),look:

and some of my errors,for no reason !!:
Code:

#include <a_mysql>

#define mysql_host "127.0.0.1"
#define mysql_user "root"
#define mysql_password ""
#define mysql_database "server"

public OnPlayerDisconnect(playerid,reason)
{
    new score = GetPlayerScore(playerid),money = GetPlayerMoney(playerid),query[300], pname[24];
    GetPlayerName(playerid, pname, 24);
    format(query, sizeof(query), "UPDATE `playerdata` SET `score` = '%d', `money` = '%d' WHERE `user` ='%s'", score, money, pname);
        mysql_query(query); // 30
        return 1;
}

public OnGameModeInit()
{
    mysql_debug(1);//66
        mysql_connect(mysql_host,mysql_user,mysql_database,mysql_password);
        mysql_query("CREATE TABLE IF NOT EXISTS playerdata(user VARCHAR(24), password VARCHAR(41), score INT(20), money INT(20))"); // 68
        return 1;
}
public OnGameModeExit()
{
        mysql_close();
        return 1;
}

just this :| and look at errors:
(30) : error 035: argument type mismatch (argument 1)
(66) : warning 206: redundant test: constant expression is non-zero
(66) : warning 215: expression has no effect
(68) : error 035: argument type mismatch (argument 1)

yup my first try with mysql :)
coding is easy,but about PHP and idk :|
thanks for reading :) , i wish u answer :p


Aucun commentaire:

Enregistrer un commentaire