Ok so I realized the other day that I have a table with picture urls in it, but some of those pictures are part of an inactive album, so they can't be displayed.

Unfortunately on the home page I have a random image displayed....which also displays inactive album pictures, so I'm trying to update it to not include those.

currently I have...

PHP Code:

$random_pic = mysql_fetch_array(mysql_query("SELECT * FROM pictures ORDER BY RAND() LIMIT 1"); 


but I want it to include

PHP Code:

WHERE AlbumID != '###' && AlbumID != '###' ... 


I have tried implementing that after 'pictures' and after LIMIT 1, but each time it gives me an error saying the supplied argument is invalid.

What's the proper syntax?

I think what you're looking for is AND.

PHP Code:

$random_pic = mysql_fetch_array(mysql_query("SELECT * FROM pictures ORDER BY RAND() WHERE AlbumID != '###' AND AlbumID != '###' LIMIT 1"); 


I would recommend adding an "active" field to your table instead of checking the id's. You could then just do,

PHP Code:

WHERE active = 'yes' 


well I was thinking about that, but what I have is an albums table with and activeAlbum column in it, which I planned on using. Find the inactive album, get their id's, etc.

so I'm kind of reluctant to add another column to the pictures table then change some things to apply that.

I'm gonna fiddle around using AND instead of && and I'll let you know.


::EDIT::
Worked like a charm. It's so disheartening making those silly mistakes. thanks a bunch for pointing it out

and for anyone who is curious...the query that worked...

PHP Code:

"SELECT * FROM pictures WHERE AlbumID != '101' AND AlbumID != '102' ORDER BY RAND() LIMIT 1" 


Originally Posted by kbfirebreather

well I was thinking about that, but what I have is an albums table with and activeAlbum column in it, which I planned on using. Find the inactive album, get their id's, etc.

so I'm kind of reluctant to add another column to the pictures table then change some things to apply that.

I'm gonna fiddle around using AND instead of && and I'll let you know.


::EDIT::
Worked like a charm. It's so disheartening making those silly mistakes. thanks a bunch for pointing it out

and for anyone who is curious...the query that worked...

PHP Code:

"SELECT * FROM pictures WHERE AlbumID != '101' AND AlbumID != '102' ORDER BY RAND() LIMIT 1" 


Heh, yeah I know what you mean. I make my fair share of obvious mistakes that I waste an hour trying to figure out what I did. Glad it worked for you.