pda4me
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";
$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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.