Accessing the correct Database in a Hosted Solution

[Mick_R_Brisbane]

Hi

anyone out there created many hosted applications. What is the best way to implement this so different user organisations will access their own database/stylesheets/defaults?

any discussion on this topic would be great....

Also, has anyone implemented a SCORM compliant API?

Mick
Australia

[iKnowKungFoo]

1 database for all sites.

Table: Sites
------------------------
SiteID
SiteName
SiteURL

Table: Settings
-------------------------
SettingID
SettingName

Table: SiteSettings
--------------------------
SiteID
SettingID
SettingValue

etc.

As for the CSS files, you could write them to disk, read to edit as needed, then rewrite to disk when updated.