SELECT DISTINCT project FROM pos LEFT JOIN region_lookup ON pos.country_id= region_lookup.country_id WHERE project <> '301' AND project <> '302' AND project <> '330' AND status <> 'canceled' AND region_lookup.region_id= '$Region' ORDER BY project
Now that I'm upgrading the database, this list of projects gets longer. Is there a way to have it combined in an array?
MySQLQuery("SELECT DISTINCT project FROM pos LEFT JOIN region_lookup ON pos.country_id= region_lookup.country_id WHERE project NOT IN (301, 302, 330) AND status <> 'canceled' AND region_lookup.region_id= '$Region' ORDER BY project