Hi, my company is currently in the works of designing and implementing a huge state of the art multimedia portal for an organisation. We would be interested in working with a PHP front end and a MYSQL backend connectivity with our hosting.

Some of the databases designed would be for:

1. Video Clips - > Search, addition, archiving
2. Audio Clips -> Same as above
3. Newspaper clips. -> scanned and linked via a database
4. Newsletters Subscription and then emailing to users stored in Database

I would like if someone could share ideas with us on this and also tell us if they have had experience in designing something similar.