Filtering a database on a database connection string

[desk2web]

Happy new year everyone!

Can someone help me please. I have a skadate script installed on a domain and want to set up sub-domains based on the users country of registration - (field is country_id) and so that the relevent sub-domain eg ireland.mydomain.com, france.mydomain.com etc only shows users from that country.

I know that I can install the skadate script within subdomains (have done already) and refer to the same primary database BUT what I want to do is only show say users registered in Ireland on the ireland.mydomain.com site.

Can this be done via the database connection string??

// MySQL Connection
define('DB_HOST', 'localhost');
define('DB_USER', 'user_skadate');
define('DB_PASS', 'abc123');
define('DB_NAME', 'user_skadate');
define('DB_TBL_PREFIX', 'skadate_');

This is the config.php database string.

Any advice or suggestions would be very gratefully recieved - please be clear in your guidance as I am not a coder!!

Thanks in advance.

[dagon]

you will have to add to any user select queries that you want to be effected:

WHERE country_id=XXX

XXX being the particular country id, this has nothing to do with your db connections, unless you have set up country specific dbs