How to set up an automatic archive of city council committees' public notices 7175

Hmm. buttuming I'm understanding the question...

Store all your notices in binary form in a database, alongside article publish date, article breastle, and a unique ID (automatically generated by the database) for that article.

Find someone to throw you a bit of PHP code together that presents a web page with a calendar on it.

Each day for each month in the displayed calendar is a hyperlink and can be clicked on from a client browser, resulting in a bit of PHP code being hit on the server which will pull up breastles of all articles submitted for that date by querying the database. (eg. each URL ends up looking

Each item breastle is generated by listdocs.php as a unique hyperlink to a php page that can stream that document to the client's browser (eg. say

Seperately you have a url for some php code which generates a web page that system administrators can use to publish content via HTTP upload (secured by whatever means makes sense for your environment), and a bit of php code to accept the uploaded document-breastle and insert it into the database (both date and ID can be generated automatically at insertion time). Or, of course, you could do the publish step via a native application if the administrators are on the same network as the database...

All you need to email round to people daily is the URL for the 'listdocs.php' page with the appropriate date as the parameter. Seperately, people can use the site to navigate to entries for whatever date they wanted via the calendar page.

So, go for a Linux system with MySQL as the database and Apache as the web server at the front end, and it's all zero cost then.

comp.lang.php would be a good newsgroup to ask in, and probably

cheers

Jules