Hi everyone,
I would appreciate your with the following problem.

My site has images of artists work on several pages which change randomly when
the page is refreshed. I would like to be able to link to the particular
artists detail page.
I am using: artists_detail.php?recordID=<?php echo
$row_rsImages1['artistID']; ?> for the link and

SELECT imagestbl.smImg1, artistinfotbl.artistID
FROM imagestbl, artistinfotbl
ORDER BY RAND() LIMIT 1
for the recordset.

The problem is that when the image is clicked the wrong detail page shows. It
seems that both the image and link are being treated separately. If I remove
the ORDER BY RAND() LIMIT 1 all is well but no random change of course. Does
anyone know of a way around this? I have been scratching my head most of today
over this and now going bald.
The test page I am using is:
http://www.scotlandsartists.com/pages/about_us.php and the link is set up on
the first image.
Thanks in advance for any suggestions

John