SELECT email,password,codeid FROM lpf_members WHERE email='#FORM.username#' AND password='#FORM.password#' and (active = 'y' or active = 'i') and password != '' and email != '' select * from lpf_members where email = '#Session.MM_Username#' and codeid = '#Session.MM_UserAuthorization#' order by lastname desc limit 1