Mysql problem, help. - Printable Version

Mysql problem, help. - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: Mysql problem, help. (/showthread.php?tid=605921)

Mysql problem, help. - AtomicSAMP - 26.04.2016

Is there anything wrong with this line?

Код:

mysql_format(dbHandle, query, sizeof(query), "INSERT INTO `apbs` (id, charge, suspect, officer) VALUES (%d, '%s', '%s', '%s')", number, charge, suspect, name);

what did I do wrong? Sorry my bad english, i'm portuguese.

Re: Mysql problem, help. - Misiur - 26.04.2016

Yup, your query column names aren't matching the db ones.
Compare

Quote:

`apbs` (id, charge, suspect, officer)

to the fields in your db.

Re: Mysql problem, help. - AtomicSAMP - 26.04.2016

Yes, yes..

Can you tell me why all IDs are states to 0?