MyBB Community Forums

Full Version: removing hidden and draft threads in SQL query
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
How do I remove hidden and draft thread this SQL query

$sorgu = @mysql_query("SELECT `tid`, `subject` FROM `".$config['database']['table_prefix']."threads` Where `fid` Not In (2) ORDER BY `lastpost` DESC LIMIT 0,$konu_sayisi");
only draft or hidden thread
guys some one help me pls?