CosmosRP Posted October 25, 2010 Share Posted October 25, 2010 Lets say I have an array of different values... for example, $alreadyViewed = array("hi.jpg","cow.jpg","dog.png"); Lets say my database contains: animals.jpg cat.jpg cow.jpg hi.jpg dog.png How do you I tell MySQL to only fetch the remaining entries? And ignore everything in the $alreadyViewed array? Quote Link to comment https://forums.phpfreaks.com/topic/216831-phpsql-help-excluding-results/ Share on other sites More sharing options...
BlueSkyIS Posted October 25, 2010 Share Posted October 25, 2010 SELECT * FROM sometable WHERE somecolumn NOT IN ('this', 'that', 'somethingelse'); Quote Link to comment https://forums.phpfreaks.com/topic/216831-phpsql-help-excluding-results/#findComment-1126435 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.