MyBB Hacks

Full Version: how to make sql not in fid
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
i would like you to help,,

this code

PHP Code:
$query = $db->query("
	SELECT * 
	FROM ".TABLE_PREFIX."threads
	ORDER BY `tid` 
	DESC LIMIT 10");


this will make last or new post from all forum,,how to make an exception?
so all thread or post from forum id (FID) 2 and 3 will not show in new post

is that like this?

PHP Code:
$query = $db->query("
	SELECT * 
	FROM ".TABLE_PREFIX."threads NOT IN FID != (2,3)
	ORDER BY `tid` 
	DESC LIMIT 10");


please help

wow thanks for your fast support,,very helpfull
Reference URL's