
01-15-2013, 03:42 PM
|
 |
|
|
Join Date: Mar 2004
Location: U.S.A
Posts: 921
Благодарил(а): 0 раз(а)
Поблагодарили:
0 раз(а) в 0 сообщениях
|
|
It shows an error Chris.
Quote:
Invalid SQL:
SELECT COUNT(*) AS users
FROM 1user AS user
WHERE 1=1 AND posts >= 1 AND lastactivity >= $timecondition
AND (user.usergroupid IN (-1,22,39,28,15,40,42,6,7,32,2,37,5));
MySQL Error : Unknown column '$timecondition' in 'where clause'
|
I then put " around the timecondition variable and it got rid of the error but it still showed every listing. I even tried changing the >= to <= but that displays a completely empty memberlist. lol
|