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.

You have two issues.... first you can't filter one recordset with a value from another directly using the default Dreamweaver recordset. Second your recordset's are in the wrong order.

First you need to move the recordsets to appear in the correct order. Copy lines 39-65 and paste them below the other recordsets maybe at the bottom just above the <!doctype> tag.

Then you will have to store a temporary variable above it. Add something like:

<?php
$_GET['artist_id'] = $row_WADAartworks['artist_id'];
?>

Then you can update the bottom recordset to filter it with the $_GET variable instead of the recordset value.

thats nice. (y) seems to work fine now. well for now lets say i m viewing id=100
& id=100 is the last artwork
and on related artworks order is DESC ID
So if i m viewing id=100, in related artworks again 100 is shown which isnt relevant.

So how to solve this problem?

i m receiving an error as :
Parse error: syntax error, unexpected '' (T_ENCAPSED_AND_WHITESPACE), expecting identifier (T_STRING) or variable (T_VARIABLE) or number (T_NUM_STRING) in /Applications/XAMPP/xamppfiles/htdocs/shrishtiart/artwork-details.php on line 152

file attached.

no more errors. something was wrong with it. well how can we do the above thing as discussed earlier?

About not displaying same artwork in related artwork section

If you update line 152 of the file you sent earlier to:

$query_RelatedArtworks = "SELECT * FROM artworks WHERE artist_id = ".$row_WADAartworks['artist_id']." ORDER BY id DESC";

I think it would work.

it works. thnks

what about not displaying same artwork when its been viewed?

You could store an array of viewed artwork in the SESSION and then filter out that array from your recordset. This is something we could help with in a premier support ticket.