SQL: SELECT m.uid,m.username,m.usr_geo,mf.nickname,mf.avatar from [Table]members m LEFT JOIN [Table]memberfields mf ON m.uid=mf.uid WHERE mf.avatar != >'100. ORDER BY rand() LIMIT 20
Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '>'100. ORDER BY rand() LIMIT 20' at line 1
Errno.: 1064
Similar error report has beed dispatched to administrator before.
$query_avatar = $db->query("SELECT m.uid,m.username,m.usr_geo,mf.nickname,mf.avatar from {$tablepre}members m LEFT JOIN {$tablepre}memberfields mf ON m.uid=mf.uid WHERE mf.avatar !='' ORDER BY rand() LIMIT 20");