Re: performance suggestions
| From: | Joe Belmaati | Date: | Sun, 13 Nov 2005 09:56:54 +0000 |
| Subject: | Re: performance suggestions | ||
| References: | 1 2 3 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-225692@lists.php.net to get a copy of this message | ||
$sql = "SELECT u.*, s.*, p.*
FROM URL u, session s, page p
WHERE u.url_id = s.url_id
AND s.section_id = p.section";
if (!$result = mysql_query($sql))
{
die('Could not obtain results');
}
while ($row = mysql_fetch_array($result))
{
$url = $row['url_name'];
..........
..........
and what ever else you want to do here;
}
"James Benson" <jb@jamesbenson.co.uk> wrote in message
news:37.4E.05064.5B571734@pb1.pair.com...
> 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
> >