Adding an array in a SQL query
leefish Offline
Hamster
*****
Posts: 1,009
Joined: Apr 2010
Post: #7
RE: Adding an array in a SQL query
Thanks Techu - I'm gonna do a bit more work on it - adding totals and such - but its biggest flaw right now is that its not really shareable as its calling my field names for the upload file keys from Custom Thread Fields. I am struggling to replace the data in this piece of the query with something more generic Frown

Code:
AND (a.field = 'fupload' OR a.field = 'fupload2' OR a.field = 'fupload3' OR a.field = 'fupload4')


Really it should be calling the upload mime but the "/"symbol in the rar and zip uploadmime types is beating me right now.



[Image: leelink.gif]
MYBB1.6 & XThreads
11-02-2010 12:35 PM
Visit this user's website Find all posts by this user Quote this message in a reply

« Next Oldest | Next Newest »

Messages In This Thread
Adding an array in a SQL query - leefish - 11-02-2010, 04:58 AM
RE: Adding an array in a SQL query - RateU - 11-02-2010, 05:42 AM
RE: Adding an array in a SQL query - RateU - 11-02-2010, 07:02 AM
RE: Adding an array in a SQL query - techu - 11-02-2010, 12:16 PM
RE: Adding an array in a SQL query - leefish - 11-02-2010 12:35 PM
RE: Adding an array in a SQL query - RateU - 11-03-2010, 07:31 AM

 Standard Tools
Forum Jump: