SELECT M.keywords,M.memberID,M.displayName,M.memberDob,M.rateCount,M.seoUri,M.vanityUrl,M.aboutMe,M.imageName,M.shopBanner,M.viewCount,M.memberSecretQuestion,M.answerSecretQuestion,M.companyName,M.fbLink, M.viewCount,M.mobileNumber,M.memberEmail,M.memberAddress,M.zipCode,M.memberType,M.memberPackage,M.duration,M.profileStep,M.imageCounter,M.videoCounter,C.cityName,S.stateName FROM mx_member AS M LEFT JOIN mx_city AS C on C.cityID = M.cityID LEFT JOIN mx_state AS S on S.stateID = M.stateID WHERE M.memberID= AND M.status='1'
SELECT M.keywords,M.memberID,M.displayName,M.memberDob,M.rateCount,M.seoUri,M.vanityUrl,M.aboutMe,M.imageName,M.shopBanner,M.viewCount,M.memberSecretQuestion,M.answerSecretQuestion,M.companyName,M.fbLink, M.viewCount,M.mobileNumber,M.memberEmail,M.memberAddress,M.zipCode,M.memberType,M.memberPackage,M.duration,M.profileStep,M.imageCounter,M.videoCounter,C.cityName,S.stateName FROM mx_member AS M LEFT JOIN mx_city AS C on C.cityID = M.cityID LEFT JOIN mx_state AS S on S.stateID = M.stateID WHERE M.memberID= AND M.status='1'
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND M.status='1'' at line 6