Thank you for your reply. I am trying to keep this as simple as possible, so I am using only one table. The table has the following fields:
ID: INT A_I PRIMARY
username: VARCHAR (30)
password: VARCHAR (30)
file: VARCHAR (60)
isADMIN: ENUM 0,1
I have a webpage for ADMIN login which will use the 'isADMIN' field to allow access, and I have the CLIENT LOGIN page for obviously the clients. The clients login will only be available for a short period of time. For that reason, she has to be able to delete the records. She has another program to keep their information in.
When logging in, the clients MUST enter Session ID, Username, Password. After clicking Login, I want to query or search for their username along with the session ID and narrow the result to ONLY show that record. There will be times when one client has more than one session, so querying for that record would solve confusion. When the next page loads, I want that record to show up with the Username, sessionID, and File (whether or not it is a hyperlink or actual file). I have no problem making the login pages, its getting the system to query and SHOW the results on the next page. And the same goes with the ADMIN page, except I want it to show all records and after adding or deleting a client, the page refreshes to show the updates. I know little about coding this. So please help and show me if this is possible. Thank you.