Want to track User Title in the Sessions table

[JoshFink]

If someone could help me out with this, I would really appreciate it. I want to track user title in the sessions table. Now I know I need to add a column in the sessions table called usertitle, but how would I go about updating that table with the usertitle everytime the sessions table is updated?

Thanks Alot,

Josh

[JoshFink]

Anyone have a clue?

Thanks,

Josh

[JamesUS]

Why do you need to track user titles? If you use a query like this:

SELECT * FROM session LEFT JOIN user ON user.userid=session.sessionid WHERE userid=$userid;

That will give you access to all records from the user table (usertitle, username etc) and all records from the session table as well.

[JoshFink]

I want to try and lessen the amount of queries that I'm running. it's something that's going to run right by the Who's online, so I figure if it's already in the table then I will save a qeury and not slow things down.

Thanks,

Josh

[Freddie Bingham]

If you were to change this line

SELECT DISTINCT session.userid,username,invisible

to

SELECT DISTINCT session.userid,username,invisible,usertitle

in index.php you would have access to the usertitle of each person logged in.