Re: performance suggestions
| From: | Richard Lynch | Date: | Wed, 09 Nov 2005 03:34:22 +0000 |
| Subject: | Re: performance suggestions | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-225381@lists.php.net to get a copy of this message | ||
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