Adding an array in a SQL query
ZiNgA BuRgA Offline
Fag
*******
Posts: 3,357
Joined: Jan 2008
Post: #8
RE: Adding an array in a SQL query
What are you trying to pull exactly?
From the query, it seems like you're pulling the latest threads which have at least one of the specified xtattachments attached to the thread.
If it's a list of fields, you're probably going to need the user to enter what fields they're using at some place.

As for the above post, are you trying to filter by type?  You shouldn't trust the MIME type as this is sent by the user and XThreads doesn't do any validation on it (it just stores it in case there may be a use in the future).  Checking file extensions is probably more reliable.

My Blog
11-02-2010 01:02 PM
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 - ZiNgA BuRgA - 11-02-2010 01:02 PM
RE: Adding an array in a SQL query - RateU - 11-03-2010, 07:31 AM

 Standard Tools
Forum Jump: