Defining a constant (I think!)

[pixelhousedesign]

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.

[johnny86]

If I understand the definition correctly, it will be used in a SQL query. So you could try:

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