Pages are "created" from within an administration utility that is part of the Mambo CMS. I'm not sure how best to explain it really, CMS by its nature is a content/news/blog system. I've used add-on modules and components to create what you see. Individual web pages are all based on stylesheets to control their look and feel, you can then add menu items that perform differing functions using the modules and components. In the case of my "Weather websites" these are all done using a 'wrapper' component that takes content that I define and wraps the Mambo look around them. Its a very different concept to get used to initially but once you have the hang of it you can do all sorts of things. If you allow people to create an account on your site they can even change the template to one from a pre-installed list, which gives them control of how the whole site looks when they log on. They could also post there own content if that is something you have allowed. I'm using it in a very simple form, no user logons.
The back end is MySql, Perl/CGI based. Mine is done via a hosting service called l40.com in the US. They offer a huge array of management facilities for (in my case) about USD$7.95 per month.