Related Product not appearing.
this website is for displaying artworks.
Every artwork got an artist_id
So lets say i m viewing at a artwork (artworks-details.php) of artist_id = 2
So then i got a section where i wanna show other artworks of same artist ie artist_id=2
I created this RS:
SELECT *
FROM artworks
WHERE artist_id = colname
colname: int -1 $row_WADAartworks['artist_id']
WADAartworks is RS of artwork.
Now other artworks are not displaying. not sure where i have gone wrong.
Page attached.