how do i fix this
SELECT IF(userid > 0, 1, 0) as isuser, COUNT(session.userid) as online_users
, user.market_username_color,
user.market_username_glow, market_username_subscript
FROM session as session
WHERE session.lastactivity > 1308226966
GROUP BY isuser;
MySQL Error : Unknown column 'user.market_username_color' in 'field list'
Error Number : 1054
Request Date : Thursday, June 16th 2011 @ 02:37:46 PM
Error Date : Thursday, June 16th 2011 @ 02:37:47 PM
Script : online.php
Referrer : forum.php
IP Address :
Username :
Classname :
MySQL Version : 5.1.43
|