Digital Workshop

I have a client who has requested the following:

She maintains an online calendar and enters various agents details against certain events.

The Agent logs in using a password, but can only see events that are assigned to them.

I use Microsoft Access and am not that good at PHP and SQL, can anybody give me any advice how this can be done.

Thanks

In purely abstract terms, you would simply only provide query statements that filter the results returned... in SQL by including the WHERE part of the statement.

e.g. SELECT blah blah blah WHERE Userid = userlogonname

Of course, any events or tracking entries entered into the DB should have a value entered for userlogonname. (if an admin person is doing this... you could create another field like UserAlias, and 'filter' on that instead.)

I'll leave it to the PHP gurus to coach on the web stuff.