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? 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'); Link to comment https://forums.phpfreaks.com/topic/216831-phpsql-help-excluding-results/#findComment-1126435 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.