Jon Fowler wrote, > I have a database of publications I want to do the following: > > > - Show data from the database in a table on a wiki page > - I want to be able to format the table's font, size, etc. > - I want the database to be in a simple format that most people can > edit i.e. csv, xls or mdb > - I want the table on the WIki page to update when the database > updates
Hi, Jon. If the database is in MySQL, then the SelectQuery recipe is the easiest way to go. You can format the font, size, etc. in your skin's stylesheet. If you need more flexibility, the DataQuery recipe is far more configurable and powerful, gives you much more control over how the information is displayed, and allows you to edit as well as display the data, and to limit who can view or edit which data. However, neither recipe makes the data available in csv, xls, or mdb... just HTML, which copies and pastes pretty well into Excel or OpenOffice. If you need to be able to export to a file, your best bet is probably phpMySQL... set up a guest account there and direct people to the export page for the relevant table. Hope this helps. --Ben S. _______________________________________________ pmwiki-users mailing list [email protected] http://www.pmichaud.com/mailman/listinfo/pmwiki-users
