Page 1 of 1

Guitar site with dynamic data

Posted: Sun Jun 24, 2007 8:03 pm
by olavt
The redesign and redevelopment of my site has come to a point where I can show it off. It uses a lot of dynamic data that is stored in a MySQL database outside CMSMS. I am using user defined tags to select and sort data from the database and to present the result with CMSMS.

There are still some lay out issues I hope to solve. When it is right in Opera, it is wrong in IE. When it is right in IE, it is wrong in Opera and Firefox, etc. But it is starting to look like something, and the content is there.

I do not think I would have been able to do this without CMSMS - at least not in a long time.

http://www.torvund.net/guitar/

Re: Guitar site with dynamic data

Posted: Mon Jun 25, 2007 7:52 am
by geometrikal
hey matey

I used these hacks for my page:

/*
*
*  Hacks
*
*/
/* Remove blue border for links and line under images */
img {
border: 0px;
vertical-align: bottom;
}
/* Try to get rid of space above first p in div */
div > p:first-child {margin-top:0;}

/* IE Hacks */
#primary-nav li li {
  float: left;
  clear: both;
}
#primary-nav li li a {
  height: 1%;
}

Re: Guitar site with dynamic data

Posted: Sat Sep 19, 2009 2:56 pm
by jamiebrwr
This may have been asked before but I can not find it and the search function on this forum isn't much help.

Anyway how do you pull the dynamic data that is stored in a MySQL database from outside CMSMS? Sorry I am noobie to mysql and php. As far as I know I need to have a connect.php script to to connect to mysql I have seen tuts on that. But where do I store those php files and how do access them with cmsms? How do I use the user defined tags to to call the data stored in a MySQL database?

Thanks for the help in advance.  :)

Re: Guitar site with dynamic data

Posted: Mon Sep 21, 2009 7:25 pm
by ironblaze94
jamiebrwr wrote: This may have been asked before but I can not find it and the search function on this forum isn't much help.

Anyway how do you pull the dynamic data that is stored in a MySQL database from outside CMSMS? Sorry I am noobie to mysql and php. As far as I know I need to have a connect.php script to to connect to mysql I have seen tuts on that. But where do I store those php files and how do access them with cmsms? How do I use the user defined tags to to call the data stored in a MySQL database?

Thanks for the help in advance.  :)
Create a UDT with the PHP minus the PHP tags.

Re: Guitar site with dynamic data

Posted: Tue Sep 22, 2009 3:11 pm
by jamiebrwr
Thanks a lot I'll try that and post the results.  :)