[dusk]

I am trying to create a vehicle system. And i want player to be able to have more than 1 car.
My question: is it possible to make auto numeration for every player? That there would be 1,2,3 for everyone. Because increment just numbers for everyone.
Hope you understood

[Vince]

Create a table for vehicles if you haven't already. Create a combined primary key, consisting of the userid that's in your player's table (use foreign keys) and the auto_increment vehicleid from the vehicle's table. Then your table could look something like:

userid	vehicleid	model
1	1	522
1	2	402
2	3	600

[dusk]

Okay...i thought i understand,but i don't. How do i create a combined primary key?

EDIT. How do i create a foreign key? Once again i think i understood how to do else.

[dusk]

bump

[dusk]

How do i set a foreign key on already existing tables?

[Misiur]

Easiest way would be with pma - add index key, then switch to relative view and add foreign key

[dusk]

could you eplain it slower ?

[Misiur]

phpMyAdmin - if you are working on your computer, I can assume that you are running WAMP/XAMPP or something like this so it should be included by default. Also almost every webhosting has it

[dusk]

I use webhosting. What is relative view?

[dusk]

bump