Mysql Errorid 1064
#7

Quote:
Originally Posted by Shaneisace
View Post
pawn Code:
case 0:
        {
            if(!response)return Kick(playerid);
            mysql_format(gConnectionHandle, Query , "SELECT * FROM 'users' WHERE Username '%s' AND Password = md5('%s')",GetName(playerid),inputtext);
            mysql_function_query(gConnectionHandle , Query , false ,"LoginPlayer" , "ii" , playerid,inputtext);
       
        }
        case 1:
        {
            if(!response)return Kick(playerid);
            new IP[50];
            GetPlayerIp(playerid,IP,sizeof (IP));
            mysql_format(gConnectionHandle, Query, "INSERT INTO `users` (`Username`, `Password`, `Money`, `Score`, `Admin`, `Kills`, `Deaths`, `IP`) VALUES('%s' , md5('%s'), 5000, 0, 0, 0, 0, '%s')",GetName(playerid),inputtext,IP);
            mysql_function_query(gConnectionHandle, Query, false , "OnQueryFinish", "ii",Query);
            GivePlayerMoney(playerid,5000);
            SetPlayerScore(playerid,0);
        }
You forgot 'users' in the first query, -> `users` or users
Reply


Messages In This Thread
Mysql Errorid 1064 - by Admigo - 18.02.2013, 17:57
Re: Mysql Errorid 1064 - by Gamer_Z - 18.02.2013, 18:03
Re: Mysql Errorid 1064 - by Shaneisace - 18.02.2013, 18:04
Re: Mysql Errorid 1064 - by Admigo - 18.02.2013, 18:18
Re: Mysql Errorid 1064 - by Vince - 18.02.2013, 20:17
Re: Mysql Errorid 1064 - by Shaneisace - 19.02.2013, 02:26
Re: Mysql Errorid 1064 - by 3ventic - 19.02.2013, 09:03
Re: Mysql Errorid 1064 - by Admigo - 19.02.2013, 17:46
Re: Mysql Errorid 1064 - by Gamer_Z - 19.02.2013, 20:35
Re: Mysql Errorid 1064 - by BlackBank - 19.02.2013, 20:52

Forum Jump:


Users browsing this thread: 1 Guest(s)