Page 1 of 1
Displaying results from another MySql database in an CMSMS web page
Posted: Mon Aug 18, 2008 2:16 pm
by burlington
I am running a CMSMS website.
I want to be able to display the results from another MySql database, which carries stats, in a normal CMSMS webpage.
How would I go about this please? Using an inline frame, or is there a better method?
Thank you.
Martin
Re: Displaying results from another MySql database in an CMSMS web page
Posted: Mon Aug 18, 2008 2:39 pm
by tyman00
I guess it all depends where your database is and if it accepts remote connections (assuming that the database is on another sever).
Are the stats already provided for you in a formatted form? If so an inline frame would likely be the easiest. Another way would be to use the existing code to create a UDT and insert the UDT in your CMSMS page.
Re: Displaying results from another MySql database in an CMSMS web page
Posted: Mon Aug 18, 2008 2:51 pm
by burlington
Thanks Tyman00
The database is on the same domain though whether it is actually on the same server as the CMSMS one is questionable.
I already get the stats in a formatted form from the database but have to clone the page header etc to match the main website. Therefore I suppose an inline frame would be best
Sorry, but what is a UDT?
Regards
Martin
Re: Displaying results from another MySql database in an CMSMS web page
Posted: Mon Aug 18, 2008 2:59 pm
by tyman00
burlington wrote:
Thanks Tyman00
The database is on the same domain though whether it is actually on the same server as the CMSMS one is questionable.
I already get the stats in a formatted form from the database but have to clone the page header etc to match the main website. Therefore I suppose an inline frame would be best
Sorry, but what is a UDT?
Regards
Martin
In this situation it would probably be easiest to use an iFrame.
UDT:
http://wiki.cmsmadesimple.org/index.php ... fined_Tags
Re: Displaying results from another MySql database in an CMSMS web page
Posted: Mon Aug 18, 2008 3:07 pm
by burlington
Thanks, will try it
Martin