Link to home
Start Free TrialLog in
Avatar of stormist
stormist

asked on

PHP MySQL query rejecting results that are in an array

How would I go about executing a MySQL query of say Limit 10 but only returning results that are not in an array? Kind of like the NOT IN () mysql function but not in a PHP array?

ASKER CERTIFIED SOLUTION
Avatar of zreak
zreak

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of stormist
stormist

ASKER

Wow is it really that simple? I'm trying it now! :)
Yea, but it tends to be really slow!
hmm any way to speed it up?
Did you try it out?  It maybe fast enough for your application.
Well I am applying it to a few places, so it'll prolly be a day or two until i fully test it out. Was just leaving thread open a little longer to get more input and possibilities I appreciate any comments you might have!
I've had "NOT IN" worked well in MySQL and a different query with "NOT IN" in MSAccess that was way too slow, but it could have just been the amount of data or just the fact that MSAccess is in inferior (probably the latter).