Mysql - update multiple rows!
#3

I want to be able to delete cars ingame using a command like /deletecar. The command does that:

Код:
		    format(queryString, sizeof(queryString), "DELETE FROM vehicles WHERE vehicleID = %d", GetPlayerVehicleID(playerid));
		    mysql_query(queryString);
But, if I have 5 cars in the database with the ids 1,2,3,5 and 9 and I try to delete the car with the id 9 (by getting in the car and typing /delete), the car that will be deleted will be car with id 5, because in SAMP the ids of the cars are in order.

Another solution it would be if I would be able to delete the fifth row. Don't know if that's something that you can do in SA:MP.
Reply


Messages In This Thread
Mysql - update multiple rows! - by im - 04.03.2012, 18:04
Re: Mysql - update multiple rows! - by Vince - 04.03.2012, 18:30
Re: Mysql - update multiple rows! - by im - 04.03.2012, 18:41
Re: Mysql - update multiple rows! - by Gamer_Z - 04.03.2012, 20:55
Re: Mysql - update multiple rows! - by im - 05.03.2012, 06:12
Re: Mysql - update multiple rows! - by jameskmonger - 05.03.2012, 06:22
Re: Mysql - update multiple rows! - by Gamer_Z - 05.03.2012, 13:52

Forum Jump:


Users browsing this thread: 1 Guest(s)