[rickysaltzer]

Originally Posted by BrettMo

Some help with some SQL please...

I want to exclude a few galleries from showing up in the thumbs on my home page. How would I change the SQL to not pull pics from them? Thanks.

Current SQL:

PHP Code:

$photoplog_file_infos = $db->query_read("SELECT *
                        FROM photoplog_fileuploads
                        WHERE moderate = 0
                        ORDER BY RAND()
                        LIMIT 4 


If you want to use a static Image, start by going to where the image is located using PhotoPlog, look at the URL , you'll notice at the end it says "n=x" x being the fileid #.

So, I just modified the SQL query to get only that image. Here is what I got

$photoplog_file_infos = $db->query_read("SELECT *
						FROM photoplog_fileuploads
						WHERE fileid = 4

4 being the x that was in my URL.

Hope this helps