I would like to have a login interface that will allow any unique user to give a username and password. Should I create a separate table for this, OR should I use the mysql.user table and set the permissions for the user through PRIVILIGES?
After the username and password are entered, a function will call the mysql_connect with that information to get a resourceID for that user. That user then will be presented with data from the mysql database by SELECT and mysql_query. The data is presented to the user as HYPERTEXT links that refer to other php files. Those PHP files will need to run queries as well to present the data as HYPERTEXT links....so one and so forth. So I need to allow a user to get a database connection they can use to navigate the website and have multiple SELECT queries executed on different php files. Any suggestions? It appears to me that I have to either pass the $dbcnx variable containing the connection resource ID of the mysql_connect function, but I do not believe this works between PHP files. OR I have to send the username and password to each PHP and reconnect using mysql_connect. Any suggestions and/or links to sites with this type of scenerio? Thanks in advance.