rating in portal announcement

[duhol]

i think i have to put threadratings query inhere:

PHP Code:

1 2 3 4 5 6 7 8 9

$announcements = ''; $query = $db->query(" SELECT t.*, t.username AS threadusername, u.username, u.avatar, u.avatardimensions FROM ".TABLE_PREFIX."threads t LEFT JOIN ".TABLE_PREFIX."users u ON (u.uid = t.uid) WHERE t.fid IN (".$announcementsfids.") AND t.tid IN (0{$tids}) AND t.visible='1' AND t.closed NOT LIKE 'moved|%' ORDER BY t.dateline DESC LIMIT 0, {$numannouncements}" );

---

but i dont know how and i dont know how to make condition

PHP Code:

$rated = ???

---

i try, but didnt work

BUT if i rate announcement once i cant do it again, cause there is an info that i already rate announcement. so, i cant rate two times on the same announcement.