define statement hep needed please

[desk2web]

Can someone help me out, I had a guy make some great changes to a script. works perfectly - however I want to modify it further and he's unavailable till tomorrow to discuss.

Hopefully someone will be able to guide me:

define('TBL_PROFILE_COUNTRY_FILTER', 'country_id = \'IE\'');

This line is based on users in a database from Ireland (IE) but what I need to do is make it so that this TBL_PROFILE_COUNTRY_FILTER doesnt just filter Ireland members but also those from Northern Ireland (Ni) as well.

So my question is this - can I (and if so how) - can I add Ni to this define statement.

Grateful for any guidance (php isn't my thing at all but I'm trying to pick up what I need when I need it).

Thanks again.

[laserlight]

I would guess either:

define('TBL_PROFILE_COUNTRY_FILTER', "`country_id` = 'IE' OR `country_id` = 'Ni'");

or:

define('TBL_PROFILE_COUNTRY_FILTER', "`country_id` IN('IE', 'Ni')");

This seems to be more a matter of the SQL rather than the define, actually.