Hi Robert,
I have written a number of Opus web publications which incorporate video - an example
here.
If you want a video to display as soon as your user loads a page then you need to stream it. I convert all video to Flash files (swf or flv format) using
ImTOO MPEG Encoder to convert the video files and use
Wimpy Wasp to stream them. Both these are modestly priced. There are free programs available which will convert video to swf and which will stream these, but I have never had much success with them
I think you will need to use a script of some description to solve your second problem. I would use PHP scripts to read and manipulate the variables sent using Post Web Data and store the results in a MySQL database.
All of the above files - Opus Publication, multimedia files, documents, a copy of Wimpy Wasp and PHP scripts need to be uploaded to your web space.