$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
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
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,
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
4 matches
Mail list logo