Ok, I can now see the images of the table structure you posted. Thanks
I see this is the detail page, and you will have passed a get parameter to it, but I also notice the recordset called WADAartworks has 3 filter parameters, two of which are using the same value, and also a session value
Please explain what you are expecting to see in the results.
eg are you clicking on the name of a piece of art on a list and wanting to display its details on this page ?
if this is the case, then this is what i would do...
drop the lol recordset, you don't need it
change the WADAartworks recordset to accept a single parameter and add the inner join here, (to display the artist name)
change the select statement to
$query_WADAartworks = sprintf("SELECT artworks.id, artists.name, artworks.artname, artworks.img, artworks.description, artworks.medium, artworks.art_size, artworks.art_style, artworks.year, artworks.price, artworks.category FROM artworks INNER JOIN artists ON artworks.artist_id=artists.id WHERE artworks.id = %s", GetSQLValueString($Paramid_WADAartworks, "int"));
change the displayed value in the table for the artist to reflect that this informaton is now coming from the WADAartworks recordset
