artwork-details.php :
rsnextid:
SELECT id
FROM artworks
WHERE id > colname
colname: $_GET['id']
rspreviousid:
SELECT id
FROM artworks
WHERE id < currentid
ORDER BY id DESC LIMIT 1
currentid: $_GET['id']
rsminmaxid:
SELECT min(id) AS MinID, max(id) AS MaxID
FROM artworks
Above are details of artwork-details.php
So from above 3 RS where we need to change?
"you will have to also update the recordset on the results page"
results page is artworks.php
ie: http://www.shrishtiart.com/artworks.php
file attached