I am trying to find the shortest path that is required to fetch data about all test centres. Each test centre allows you to query upto 5 other test centres from that centre (e.g when logged in as test centre 1 you can fetch details about test centres 2,9,12,26,30) However I would then have to log into test centre 2 to fetch details about other centres e.g 10,13,16.
The dataset is concerning around 300 test centres.
My database structure is below:
CREATE TABLE IF NOT EXISTS
testcentre1 int(10) NOT NULL,
testcentre2 int(10) NOT NULL,
PRIMARY KEY (
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
Many thanks in advance,