tools for MySQL-based web sites

I'm building a MySQL database that will be published to a website, and
I'm looking for good ways to (a) publish it and (b) enter the
information and maintain it. The rest of the system is in Perl, hence my
posting the question here. Here's some more information:

data structure
--------------
- mostly text based
- most data entered by hand, some automatically loaded
- links between items (mostly a tree but a DAG when inspected closely)
- enumerated types (with extensible enumerations)

requirements
-------------
- build HTML pages from db (main method of use).
- output XML documents from db (dumps of subsets of the content).
- enter and maintain via simple user interface, with as much of the
interface derived from the db content as possible. Could be HTML forms
or something else (e.g. X-based GUI)

other
-----
I'm running on Linux with Apache.
Not wedded to Perl if there are better solutions elsewhere.
I'd prefer free software (in both senses of free).

I'd welcome any thoughts anybody has.

Thanks and regards,
Dave

--
Dave Howorth
MRC Centre for Protein Engineering
Hills Road, Cambridge, CB2 2QH
01223 252960


--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org