<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2800.1400" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=220400615-29032004><FONT face=Tahoma>Anyone got good PHP /
mySQL skills?</FONT></SPAN></DIV>
<DIV><SPAN class=220400615-29032004><FONT face=Tahoma></FONT></SPAN> </DIV>
<DIV><SPAN class=220400615-29032004><FONT face=Tahoma>I've got a problem with a
recursive table definition that I am having hassles with and cannot get to
comply (it seems it has anti-Assimilation technology).</FONT></SPAN></DIV>
<DIV><SPAN class=220400615-29032004><FONT face=Tahoma></FONT></SPAN> </DIV>
<DIV><SPAN class=220400615-29032004><FONT face=Tahoma>The basis is storage of
locations around the globe, with the ability to get more and more
specific.</FONT></SPAN></DIV>
<DIV><SPAN class=220400615-29032004><FONT face=Tahoma></FONT></SPAN> </DIV>
<DIV><SPAN class=220400615-29032004><FONT face=Tahoma>AU -> WA -> Perth
-> Bayswater -> XX Street</FONT></SPAN></DIV>
<DIV><SPAN class=220400615-29032004><FONT face=Tahoma>AU -> WA ->
Kalgoorlie -> YY Street</FONT></SPAN></DIV>
<DIV><SPAN class=220400615-29032004><SPAN class=220400615-29032004><FONT
face=Tahoma>AU -> WA -> Kalgoorlie -> YZ
Street</FONT></SPAN></SPAN></DIV>
<DIV><SPAN class=220400615-29032004><SPAN class=220400615-29032004><SPAN
class=220400615-29032004><FONT face=Tahoma>AU -> WA -> Kalgoorlie -> YX
Street</FONT></SPAN></SPAN></SPAN></DIV>
<DIV><SPAN class=220400615-29032004><FONT face=Tahoma>AU -> NSW -> Sydney
-> Surry Hills -> ZZ Street</FONT></SPAN></DIV>
<DIV><SPAN class=220400615-29032004>
<DIV><SPAN class=220400615-29032004><FONT face=Tahoma>AU -> NSW -> Sydney
-> Surry Hills -> ZY Street</FONT></SPAN></DIV>
<DIV><SPAN class=220400615-29032004>
<DIV><SPAN class=220400615-29032004><FONT face=Tahoma>
<DIV><SPAN class=220400615-29032004><FONT face=Tahoma>AU -> WA -> Perth
-> Como -> XY Street</FONT></SPAN></DIV>
<DIV><SPAN class=220400615-29032004><SPAN class=220400615-29032004><FONT
face=Tahoma>AU -> WA -> Perth -> XZ
Street</FONT></SPAN></SPAN></DIV>
<DIV><SPAN class=220400615-29032004><SPAN class=220400615-29032004><SPAN
class=220400615-29032004><SPAN class=220400615-29032004><FONT face=Tahoma>AU
-> WA -> Perth -> XA
Street</FONT></SPAN></SPAN></SPAN></SPAN></DIV></FONT></SPAN></DIV></SPAN></DIV></SPAN></DIV>
<DIV><SPAN class=220400615-29032004><FONT face=Tahoma></FONT></SPAN> </DIV>
<DIV><SPAN class=220400615-29032004><FONT face=Tahoma>as you can see the depth
varies, and there will be specific detail at each depth.</FONT></SPAN></DIV>
<DIV><SPAN class=220400615-29032004><FONT face=Tahoma></FONT></SPAN> </DIV>
<DIV><SPAN class=220400615-29032004><FONT face=Tahoma>I have been battling using
ADOdb / PHAkt (for Dreamweaver MX/MX 2004) with infinite loops happening
:(</FONT></SPAN></DIV>
<DIV><SPAN class=220400615-29032004><FONT face=Tahoma></FONT></SPAN> </DIV>
<DIV><SPAN class=220400615-29032004><FONT face=Tahoma>Anyone give me a solution
that shows the above list, preferably something like:</FONT></SPAN></DIV>
<DIV><SPAN class=220400615-29032004><FONT face=Tahoma></FONT></SPAN> </DIV>
<DIV><SPAN class=220400615-29032004><FONT face=Tahoma>
<DIV><SPAN class=220400615-29032004><FONT face=Courier>AU </FONT></SPAN></DIV>
<DIV><SPAN class=220400615-29032004><FONT face=Courier>
<DIV><SPAN class=220400615-29032004><FONT face=Courier> -> NSW
</FONT></SPAN></DIV>
<DIV><SPAN class=220400615-29032004><FONT face=Courier> ->
Sydney </FONT></SPAN></DIV>
<DIV><SPAN class=220400615-29032004><FONT face=Courier>
-> Surry Hills </FONT></SPAN></DIV>
<DIV><SPAN class=220400615-29032004><FONT
face=Courier> -> ZZ
Street</FONT></SPAN></DIV>
<DIV><SPAN class=220400615-29032004>
<DIV><SPAN class=220400615-29032004><FONT face=Courier>
-> ZY Street</FONT></SPAN></DIV></SPAN> ->
WA </FONT></SPAN></DIV></DIV>
<DIV><SPAN class=220400615-29032004>
<DIV><SPAN class=220400615-29032004><FONT face=Courier> ->
Kalgoorlie </FONT></SPAN></DIV>
<DIV><SPAN class=220400615-29032004><FONT face=Courier>
-> YY Street</FONT></SPAN></DIV>
<DIV><SPAN class=220400615-29032004><SPAN class=220400615-29032004><FONT
face=Courier> -> YZ
Street</FONT></SPAN></SPAN></DIV>
<DIV><SPAN class=220400615-29032004><SPAN class=220400615-29032004><SPAN
class=220400615-29032004><FONT face=Courier>
-> YX Street</FONT></SPAN></SPAN></SPAN></DIV><FONT
face=Courier><SPAN class=220400615-29032004> </SPAN> -> Perth
</FONT></SPAN></DIV>
<DIV><SPAN class=220400615-29032004><FONT face=Courier>
<DIV></FONT></SPAN><SPAN class=220400615-29032004><FONT
face=Courier> -> Bayswater </FONT></SPAN></DIV></DIV>
<DIV><SPAN class=220400615-29032004><FONT
face=Courier> -> XX
Street</FONT></SPAN></DIV>
<DIV><SPAN class=220400615-29032004><SPAN class=220400615-29032004><SPAN
class=220400615-29032004><SPAN class=220400615-29032004><FONT
face=Courier> -> Como
</FONT></SPAN></SPAN></SPAN></SPAN></DIV>
<DIV><SPAN class=220400615-29032004><SPAN class=220400615-29032004><SPAN
class=220400615-29032004><SPAN class=220400615-29032004><FONT
face=Courier> -> XY Street</FONT></SPAN></DIV>
<DIV>
<DIV>
<DIV>
<DIV>
<DIV><SPAN class=220400615-29032004><SPAN class=220400615-29032004><FONT
face=Courier> -> XZ
Street</FONT></SPAN></SPAN></DIV>
<DIV><SPAN class=220400615-29032004><SPAN class=220400615-29032004><SPAN
class=220400615-29032004><SPAN class=220400615-29032004><FONT
face=Courier> -> XA
Street</FONT></SPAN></SPAN></SPAN></SPAN></DIV></DIV></SPAN></SPAN></SPAN></FONT></SPAN></DIV></DIV></DIV></DIV>
<DIV align=left>
<P><FONT face=Helvetica color=#000099><SPAN class=220400615-29032004>The
solution will have lots of possible uses including navigation, breadcrumbs and
more, so it could be useful for many people.</SPAN></FONT></P>
<P><FONT face=Helvetica color=#000099><SPAN class=220400615-29032004>Thanks for
the help</SPAN></FONT></P>
<P><FONT face=Helvetica color=#000099><SPAN
class=220400615-29032004><BR>Ady</SPAN></FONT></P>
<P><FONT face="Helvetica, Arial, sans-serif"
color=#000099><B></B></FONT> </P>
<P><FONT face="Helvetica, Arial, sans-serif" color=#000099><B>A</B><FONT
color=#cc0000>dy</FONT> "<B>K</B><FONT color=#cc0000>iltOtter</FONT>"
<B>G</B><FONT color=#cc0000>ould</FONT><BR></FONT><FONT
face="Helvetica, Arial, sans-serif"><FONT
face="Verdana, Arial, Helvetica, sans-serif" size=-2>Web Designer &
Administrator, Educator, Otter and Kilt Wearer<BR>Blogged @: <A
href="http://www.livejournal.com/users/kiltotter" target=_blank>Kilted
Kunundrums</A> & <A href="http://www.bdu.org/%7Eotter/" target=_blank>The
Otter's Pool</A> </FONT></FONT><FONT
face="Verdana, Arial, Helvetica, sans-serif" size=-2><BR>Useful sites:[<A
href="http://bdu.org/" target=_blank>Bears Down Under</A>] [<A
href="http://technix.org/" target=_blank>TechniX.org</A>] [<A
href="http://westozleather.com/" target=_blank>West Oz Leather</A>]<FONT
face="Helvetica, Arial, sans-serif" color=#000099><FONT
face="Helvetica, Arial, sans-serif"> [<A href="http://bdu.org/"
target=_blank>BDU.org</A></FONT></FONT></FONT><FONT
face="Helvetica, Arial, sans-serif"><FONT face="Helvetica, Arial, sans-serif"
size=-2>]</FONT></FONT><FONT face="Helvetica, Arial, sans-serif"
color=#000099><FONT color=#993300><BR><BR></FONT><B><FONT color=#cc6600
size=-2>Cookie Monster:</FONT></B> </FONT><FONT
face="Helvetica, Arial, sans-serif" color=#cc6600 size=-2>A lie is a
terminological inexactitude. - Winston Churchill <BR><FONT color=#993399>Cookies
are generated automatically and do not necessarily reflect the opinion of the
sender.</FONT></FONT><BR></P></FONT></DIV>
<DIV> </DIV></BODY></HTML>