On Thu, November 3, 2005 8:29 am, James Benson wrote: > Dear group, can someone suggest the best way to do the following > without > writing some lengthy script that (possibly) could lead to performance > issues, > > > I have three DB fields in MySQL, each has a unique ID, I cannot think > of > any ways other than pulling each tables record then looping through to > determine which one each belongs to which group then maybe placing > into > an array, > the association between them all goes like this, > > > URL:- > url_id > url_name > > section:- > section_id > url_id > section_name > > page:- > page_id > section_id > page_name http://info.com/mysql+join -- Like Music? http://l-i-e.com/artists.htm -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
