for next this seems to work:
"SELECT id FROM artworks WHERE position > %s and id > %s ORDER BY position, id LIMIT 1"
but for prev this doesn't work :
"SELECT id FROM artworks WHERE position <= %s and id < %s ORDER BY position DESC, id DESC LIMIT 1"
Prev a href:
"artwork-details.php?id=<?php echo $totalRows_rspreviousid == 0 ? $row_rsminmaxid['MaxID']:(isset($_GET['id'])?$row_rspreviousid['id']:1);?>"
Next a href :
"artwork-details.php?id=<?php echo $totalRows_rsnextid == 0 ? $row_rsminmaxid['MinID']:(isset($_GET['id'])?$row_rsnextid['id']:1);?>"