"1" points to page 1, the others don't point to the same numbers as the links indicate.
There are a number of ways to see what SQL statement you are using besides showing it to the world on a live site.
Load time is extra long due to the background images.
Thankyou for the feedback,
The 'page' numbes in the links are really more item numbers, 20 items a page
so page 2 is '21', I will be changing this, and also giving the user the option to chooses how many items to display per page.
And yes some images are defiantly to large, Again, on the to do list.
I would appreciate further explanation on your SQL comment,
Due to my circumstances i am developing the site 'live' so security is indeed inevitably a problem, and yes I was recently displaying the actual sql command to make sure it loaded the right way. But that is gone now. What are the numerous ways you mentioned?
All i can see is the url, eg "type=plecs&subtype=thumbpick&colour=gold"
I probably should rename these ...
What other ways are there?