asked on
PHP/MySQL Query, NOT Include in results
I have the existing query that is working great. How do I alter this query to make sure that any records where MLS = 1 is excluded?
$query_WADAmember = "SELECT MemberNumber, LastName, FirstName, `MemberE-mail`, MemberWebPage, Address, City, State, Zip, OfficeNameforAddress, FaxDialPhoneNumber, OfficePhoneNumber, ASSOC, MLS, APP, AFF FROM membership ORDER BY LastName ASC";
PHPMySQL ServerSQL
Last Comment
Patrick Matthews
$query_WADAmember = "SELECT MemberNumber, LastName, FirstName, `MemberE-mail`, MemberWebPage, Address, City, State, Zip, OfficeNameforAddress, FaxDialPhoneNumber, OfficePhoneNumber, ASSOC, MLS, APP, AFF FROM membership WHERE MLS <> 1 ORDER BY LastName ASC";
ASKER
How about where MLS = 1 AND ASSOC = 0
basically i want to exclude any records where assoc column = 0 and mls = 1
basically i want to exclude any records where assoc column = 0 and mls = 1
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.