Mysql doesnt insert - Printable Version

Mysql doesnt insert - 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)
+---- Forum: Help Archive (https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: Mysql doesnt insert (/showthread.php?tid=210689)

Mysql doesnt insert - NewbBeginner - 13.01.2011

Код:

format(Query, sizeof(Query), "INSERT INTO cars (Owner, Plate) VALUES (%s, %s);","City", "LS");
    mysql_query(Query);

It doesn't save, just inserts, empty query.

Re: Mysql doesnt insert - Toreno - 13.01.2011

Try this:

pawn Код:

format(Query, sizeof(Query), "INSERT INTO `cars` (`Owner`, `Plate`) VALUES ('%s', '%s')","City", "LS");
mysql_query(Query);

Re: Mysql doesnt insert - NewbBeginner - 13.01.2011

Doesn't work :S

Re: Mysql doesnt insert - Toreno - 13.01.2011

Just for a test...
try it

pawn Код:

mysql_query("INSERT INTO `cars` (`Owner`, `Plate`) VALUES ('City', 'LS')");

Re: Mysql doesnt insert - NewbBeginner - 13.01.2011

I tested this way, doesn't work. just empty lines

Re: Mysql doesnt insert - [L3th4l] - 13.01.2011

Mind posting the MySQL logs?

Re: Mysql doesnt insert - NewbBeginner - 13.01.2011

I think it's not needed.
It inserts query, Vehicle cordinats are 0, because I m not inserting them atm, but Owner and licenseplate should save, but it doesnt.

Re: Mysql doesnt insert - DVDK - 13.01.2011

Quote:

Originally Posted by NewbBeginner

I think it's not needed.
It inserts query, Vehicle cordinats are 0, because I m not inserting them atm, but Owner and licenseplate should save, but it doesnt.

Then show the logs..

Re: Mysql doesnt insert - NewbBeginner - 13.01.2011

Where can I find it ?

Re: Mysql doesnt insert - armyoftwo - 13.01.2011

in your samp-server.exe directory