This is something that has me stumped..
I have a table as follows
EndA EndB
--------------------
A B
A C
B C
C D
A E
D E
Imagine this as a table that describes potential links across a phone
network. Now supposing I wish to connect from point A to point D, one route
would be :
A to B
B to C
C to D
another would be
A to E
E to D
using only routes available from the table above.
My question is how do I query the database to return a valid route(s)
supplying only a start and end point.
ie SELECT !!route!! WHERE start=A and end=D,
Personally I don't see how this is possible without code, hence why I am
querying the brains of the world!!!
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
