Connections to the MySQL database

[RFH Reseller: UKFlyer]

I've just re-set up a gig guide but this time in MySQL and not using access.

What I want to do is allow bands / venues the ability to draw info from that database and display their gigs on their own site, saves them having to enter data twice. If I'm hosting the site, then not a problem. But what about giving out connection strings to 'third parties'. Anyway of encryping / hiding the user name and password?

I tried using an includes file linked to the dbconnection on the main site but that file is 'not found' although it does exist.

[Staff: Warren Ashcroft]

What I want to do is allow bands / venues the ability to draw info from that database and display their gigs on their own site, saves them having to enter data twice. If I'm hosting the site, then not a problem. But what about giving out connection strings to 'third parties'. Anyway of encryping / hiding the user name and password?

That isn't a great idea, you'd be better off providing an XML feed of the data from the site which third parties can use, that way you're always in control of the data third parties can access.

I tried using an includes file linked to the dbconnection on the main site but that file is 'not found' although it does exist.

If you mean across two different domains, webspace security will prevent this.

[RFH Reseller: UKFlyer]

Thanks Warren, some form of RSS feed would have been my next option.... I'll investigate further - sure I'll come up with something!