how to make sql not in fid
bekti Offline
Junior Member
**
Posts: 43
Joined: Mar 2012
Post: #1
how to make sql not in fid
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

08-19-2012 07:44 PM
Find all posts by this user Quote this message in a reply
ZiNgA BuRgA Offline
Fag
*******
Posts: 3,357
Joined: Jan 2008
Post: #2
RE: how to make sql not in fid
http://dev.mysql.com/doc/refman/5.0/en/c...http://dev.mysql.com/doc/refman/5.0/en/comparison-operators.html#f

My Blog
08-19-2012 07:48 PM
Find all posts by this user Quote this message in a reply
bekti Offline
Junior Member
**
Posts: 43
Joined: Mar 2012
Post: #3
RE: how to make sql not in fid
wow thanks for your fast support,,very helpfull
08-19-2012 07:56 PM
Find all posts by this user Quote this message in a reply

« Next Oldest | Next Newest »

 Standard Tools
Forum Jump: