Access bytehost or similar from forum

[ian2000]

Hello! I was wondering if it's possible to access a field of an external database from forumotion. I do not mean I want to access a field from the database that forumotion uses, but a separate one that I have for my game (with scores etc).

I was thinking of using byethost because it's free. It's a cloud based MySQL database.

My end goal is to be able to display a user's score on their profile by doing something like this:

Code:

SELECT score FROM Characters WHERE username = Forum_Username$ COLLATE NOCASE

I'm just not sure how to approach the actual acessing of the database itself? And how to execute a SQL command from forumotion?