Updating Issues

Hello all.

I am currently working on a project for a client that includes a text field (numerical data, a jackpot for their bingo business, to be exact) that requires daily updating from the client side.

I would like to know if anyone has done a project like this, and what solutions anyone may have implemented ot accomplish this.

My criteria from my client are as follows:
a) Must be updateable from anywhere, i.e. web-based vs. an executable or client side program.
b) Must be secure, so that any random individual cannot update without the userid/pass.

I have toyed with the idea of using a program to rewrite the HTML for this number display and then sending it to the server, however that would require opening unfettered FTP access, and I'm not 100% comfortable with allowing that. It would also require structuring a program in C or VB to create the HTML and upload it in one step.

Any ideas/thoughts/directions?

Thanks
Steve

Ok, so I have gotten to the point of having a SQL table with my value in it, and have put together a crude but simple script to alter that value at will.

Now I need to be able to get the value in the table to display in HTML, an have hit a wall. My SELECT query works properly, but when I place it into an php script to display it, my results are skewed.

Is there a simpler way other than a select statement to pull just one variable out of the db? I will be pulling the same variable every time the page displays.

Your looking at something involving PHP and MySQL.

Or you could go the easy way, do SHTML includes, and put the HTML file with the number inside and only give them FTP access to that.

__________________
Web Design And Development: Other Road Design | Problems with IE6?: KApp | My Blog: Only Nerds Allowed | Learning PHP? Lessons