MYSQL Issue With ID Fetch
#1

Hi,

What did I do wrong here, this should work? But it returns value 0, when ID should be 64?

pawn Код:
new query[256], cquery[256], vid;
                    mysql_format(dbhandle, query, sizeof query, "SELECT `id` FROM `vehicles` ORDER BY `id` DESC LIMIT 1 ;", vid);
                    mysql_tquery(dbhandle, query, "", "");
                   
                    format(cquery, sizeof(cquery), "UPDATE users SET car='%d' WHERE name='%s'", vid, sendername);
                    mysql_tquery(dbhandle, cquery, "", "");
                   
                    printf("Vehicle DB-ID: %d Saved to playername %s.", vid, sendername);
Reply


Messages In This Thread
MYSQL Issue With ID Fetch - by UnknownGamer - 13.01.2014, 06:35
Re: MYSQL Issue With ID Fetch - by Vince - 13.01.2014, 10:03
Re: MYSQL Issue With ID Fetch - by UnknownGamer - 13.01.2014, 18:05

Forum Jump:


Users browsing this thread: 1 Guest(s)