Re: performance suggestions

Thanks Richard Lynch wrote:

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