
Hi. Here in my databse.
CREATE TABLE b (
id int(10) unsigned NOT NULL AUTO_INCREMENT,
source varchar(45) NOT NULL,
destination varchar(45) NOT NULL,
distance int(10) unsigned NOT NULL,
PRIMARY KEY (id)
);
INSERT INTO b (id,source,destination,distance) VALUES
(1,'Madurai','Chennai',10),
(2,'Chennai','Bangalore',10),
(3,'Chennai','Kanchipuram',5),
(4,'Kanchipuram','Arani',15),
(5,'Arani','Arcot',20),
(6,'Madurai','Bangalore',5),
(7,'Bangalore','Kanchipuram',20);
Now i want to find the shortest path from the given source to destination based on the databse values. How do I do? Please report quickly. Thanks in advance.
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.
