SQL issues.
#1

For some reason, the following two SQL queries aren't doing anything.

pawn Code:
format(Query, sizeof(Query), "INSERT INTO `contracts` (`cID`, `ucon`, `ucen`, `price`) VALUES (NULL, '%s', '%s', '%i')", cContractor, cContractee, cContractPrice);
    mysql_query(Query);
    print(Query);

and

pawn Code:
format(query, sizeof(query), "SELECT `user` FROM accounts WHERE `user`='%s'", name);
        mysql_query(query);
        print(query);
           
        if(!mysql_num_rows())
        {
            SendClientMessage(playerid, GREY, "That name isn't in the database.");
        }
Please could someone help?
Reply


Messages In This Thread
SQL issues. - by JoelR - 30.12.2012, 06:45
Re: SQL issues. - by Abreezy - 30.12.2012, 06:56
Re: SQL issues. - by JoelR - 30.12.2012, 07:03
Re: SQL issues. - by Abreezy - 30.12.2012, 07:07
Re: SQL issues. - by JoelR - 30.12.2012, 07:08
Re: SQL issues. - by Peach - 30.12.2012, 10:39

Forum Jump:


Users browsing this thread: 2 Guest(s)