In the WHERE clause I changed 'users.randomString' to our actual values 'LEDusers.LEDUserVerificationCode' and that has removed that part of the error, however the "Notice: Undefined variable: totalRows_rsVerify in /home/led2014/public_html/user-confirm.php on line 19" remains.
Hope you can help.
Thank you
NJ