Need help with SQL query to return latest threads but not from ignored users....

[miz]

Originally Posted by KirbyDE

What about this:

[sql]select post.*, thread.* from post,thread where post.userid notin('275','135','1') AND post.threadid = thread.threadid groupbythread.threadid order by post.dateline desc[/sql]

the ignore list changes - if he add or remove ppl from ignore,
so then the query here wont work


if you have time to test
you can find a code on forumdisplay.php that dosent show threads from ignored users
try forumdisplay query and add
[SQL] order by post.dateline desc [/SQL]

to query.