i have been posting questions in other forums regarding my application, and some of their answers have led me to consider HTML. Here is the situation:
i work for a small non-profit foundation, named CEF, that is mounting a huge art retrospective regarding all the myths of the world. There are over 600 paintings, one for each myth included, each painting being derived from the text of the myth.
In its current configuration, the dbs will contain the source of the text (book title, author, publisher, page, etc.), geographical origin(s) of the myth, people(s) creating the myth, the text of the myth, and an image of the painting.
The images and the text (which can be 5 or 6 pages in length) are maintained in separate file directories and referenced from the dbs via relative paths.
The myths are divided into three main divisions: Creation, Mortality/Immortality (Paradise), and Death. University-level seminars will be conducted with speakers from around the world for each area of interest.
In conjunction with the retrospective, education programs are planned for schools, with particular emphasis on elementary children.
As well as making the app available on the web, CEF wants to give away CDs with the application. Because so many of the schools use Macs, this requires the app to be formatted for both the Mac OS and Windows. We are assuming most Linus users can open Windows apps at this point--sorry.
i am the designated programmer, and my experience is limited. i am "reasonably" experienced with VB and MS Access, "somewhat familiar" with DreamWeaver, C, C++, and am learning C# at someone's advice. We have DreamWeaver, FrontPage, Visual Studio.NET and Sql Server 2000 (which we bought for this purpose but is probably too much).
My questions in other forums have led me to consider writing the app in HTML with MySql as the back-end database. i don't know anything about writing apps for a dbs in HTML. Is this a good idea? What are the advantages and disadvantages? Pitfalls?
How would i go about it?
Any reference materials to recommend?
Would i need any software other than HTML and MySql? (PHP has been mentioned.)
Any and all suggestions and advice appreciated. Thanks.