I had set up the script just to SELECT * which was working perfectly showing all records including image file path to Image Folder.

The problems started when I introduced the page LIMIT, next & Previous function below.

Could someone have a look at it I have made notes the parts that are giving problems. Also is there a way to stop the Previous part of the function returning back to the search page I suppose I could do an IF statement to stop it appearing if there are none or only one record returned.