[norton2]

Hey, when you insert a new car in the MySQL database, how I can extract the ID from database? (Use MYSQL R39 + ORM)

Код HTML:

mysql_format(MySQLCon, query, sizeof query, "INSERT INTO vehicles (Owner, Model, Color1, Color2, Value) VALUES('%d', '%d', '%d', '%d', '%d');", pInfo[playerid][pID], dmodelid[playerid], 1, 1, dprice[playerid]);
mysql_query(MySQLCon, query);

[Vince]

cache_insert_id()

[norton2]

That's right?

Код HTML:

mysql_format(MySQLCon, query, sizeof query, "INSERT INTO vehicles (Owner, Model, Color1, Color2, Value) VALUES('%d', '%d', '%d', '%d', '%d');", pInfo[playerid][pID], dmodelid[playerid], 1, 1, dprice[playerid]);
mysql_query(MySQLCon, query);
new did = cache_insert_id();
printf("ID FROM DATABASE IS: %d", did);

[xVIP3Rx]

Yes.

[Andre02]

Yes, but

pawn Код:

printf("ID FROM DATABASE IS: %d", cache_insert_id());

also works

[norton2]

Thank you all!