UPDATE is affecting all my rows?

I know. This was a long time ago and, at the time I had lots of live websites using this version. When they finally updated, was just too much work as you can imagine, though after our chat I’m very keen to get back up to speed with this and start doing things correctly :smile:

Plus saving me a lot of coding time once I have things in place. On some pages I’m using over 6 Select Statements with numerous joins to show the data ha :tired_face:

I’ve also started a new job, been here a couple of months now and C# is in order ha .net environment windows, though some database work is involved most of it is done automatically through the CMS.

Cool, and thanks again Mittineague, no doubt I’ll be back once I start the upgrade :sunglasses: