I am using apache 2.01 for my website in fedora core 3.
I am using basic database authentication using mod_auth_mysql and authenticating the users from my own database.
My problem is, I have certain other columns in my database apart from username and password which I need to know when a user logs in. I intend to use these fields for other activities like personalization of the page etc.
How do I know the username using which the user has logged in so that I can get the other columns info in the table ? Is it possible to know at all ?
I am using php for this.