Php MyAdim problems with making tables unique

  database, mysql, php, phpmyadmin

I’m currently making a train booking system in php myadmin. I’m at the stage where I want to make each seatID (A1, A2 etc) unique to each journey (Train1, Train2 etc).

The problem is that in my Passengers table I am able to make each of the seatIDs unique so that only one passenger can choose that seat but when I do that, php myadmin doesnt make each seat unique to one journey and makes a seatID unique towards all the journeys.

for example, if a passenger chooses Seat A1 on Train1 then no one else can choose that seat on just that Train. But php myadmin reads it as if a passenger chooses Seat A1 then no one can choose it on any of the other trains I have in my database. Can anyone help?

Source: Ask PHP