[TECK]

neo (should i say firefly? )... please make me happy and add that LEFT JOIN.. actually can anyone tell me if it will bring the server to it's knees if i do this? add also the guests into it?

here what i did:

$getforumbrowsers=$DB_site->query('SELECT COUNT(*) AS count,inforum
                                   FROM user
                                   LEFT JOIN session ON (what do i put here?)
                                   WHERE lastactivity>'.($ourtimenow-$cookietimeout).'
                                   AND lastvisit<>lastactivity
                                   GROUP BY inforum');

i guess i have to add a inforum field in the session table... do i have to index it also?