$sql = "SELECT * FROM Listings WHERE status<>'sold' AND type IN('Apartment', 'Unit', 'Studio', 'Townhouse', 'Villa', 'Duplex', 'Retirement') AND suburb IN('ANSTEAD', 'PULLENVALE', 'BROOKFIELD', 'UPPER BROOKFIELD', 'PINJARRA HILLS')ORDER BY $order $ad";
cheers aron.
